Which user is running search ?

[maitrifer]

Hi All, I have a requirement I wanted to check which user is running a search. I need help in SPL query to get user and search details.

[vikramyadav · Accepted solution]

index=_audit action=search sourcetype=audittrail search_id=* NOT (user=splunk-system-user) search!="'typeahead*"
| rex "search\=\'(search|\s+)\s(?P<search>[\n\S\s]+?(?=\'))"
| rex field=search "sourcetype\s*=\s*\"*(?<SourcetypeUsed>[^\s\"]+)"
| rex field=search "index\s*=\s*\"*(?<IndexUsed>[^\s\"]+)"
| stats latest(_time) as Latest by user search SourcetypeUsed IndexUsed
| convert ctime(Latest)

--------------------------------------------------------

If this helps your like will be appreciated😊

[thambisetty]

index=_audit action=search | stats earliest(user) as user ,earliest(search) as search by search_id