I am working with JSON data type events and am trying to extract the username (user1, user2) from the pathspec data structure in my events (sample below) : "pathspec": {"__type__": "PathSpec", "location": "/media/APA_windows/Users/user1/AppData/Local/Microsoft/Windows/UsrClass.dat", "type_indicator": "OS"} "pathspec": {"__type__": "PathSpec", "location": "/media/APA_windows/Users/user2/AppData/Local/Microsoft/Windows/UsrClass.dat", "type_indicator": "OS"} I am using the below SPL to split up pathspec.location into a multi value field and then use mvindex : ..... | makemv delim="/" pathspec.location
| eval user_name = mvindex(pathspec.location, 3) However when I table out the user_name field it does not show any results. Not sure why this is not working. Any suggestions would be helpful Desired output from the user_name field would be user1
user2
.
.
.
.
.
... View more