How to find long-running searches in Splunk, with execution time in mins?

[shinde0509]

How to find long-running searches in Splunk, with execution time in mins.

[shinde0509]

Not having access to Monitoring Consoles, SO using SPL want to create dashboard.

[richgalloway]

If you don't have access to the MC then you probably don't have access to the _internal index, which is where run times are reported.

[shinde0509]

Having access to _internal and _audit Indexes.

[richgalloway]

This should get you started.

(index=_audit host=* action=search sourcetype=audittrail search_id!="rsa_*") 
| eval user = if(user="n/a", null(), user) 
| eval search_id=replace(search_id, "'(.*)'", "\1") 
| eval search=if(isnull(savedsearch_name) OR savedsearch_name=="", search, savedsearch_name) 
| stats min(_time) as _time, values(user) as user, max(total_run_time) as total_run_time, first(search) as search, first(apiStartTime) as apiStartTime, first(apiEndTime) as apiEndTime by search_id

[richgalloway]

The Monitoring Console has a dashboard for that.  See Settings->Monitoring Console->Search->Search Usage Statistics: Instance then scroll down.

[jo]

very good!!