Maybe this is what you need. Note, as far as I know there are no fields that show the index used by a search, that show the index used by searches, so you have to extract that from the SPL code, and index= can be all over the place in the code and also in macros, so its tricky, but may be this will work for you. This shows the count of searches by index_used | rest splunk_server=local /services/search/jobs
| fields author title, updated, search, runDuration, provenance, latestTime, owner eai:acl.app, diskUsage
| rename author AS user eai:acl.app AS app title AS search_code
| rex field=search_code "(?<index_used>index\s*=\s*[^ ]+|index\s+IN|search\s*=\s*index=|search\s*=\s*inputlookup\s+in|index\s*=_\*)"
| stats count(search_code) AS volume_of_searches_ran BY index_used
| sort - volume_of_searches_ran
... View more