View Summary Index query

[deepak02]

Hi,

I have been handed over a bunch of summary indexes I should be using as base.

I have full access to the Search Heads.

Is there anyway I can view the queries used by the summary indexes given their names (since the person has already left)?

Thanks,
Deepak

Note: I am using Splunk Enterprise.

[somesoni2]

If the owner of saved search using summary index has left and his account is deleted/disabled, you might not be able to search REST API endpoint. REST API approach would be better one if it can work though. If it doesn't and if you can query filesystem on the search head, I would try following grep command to locate searches using a particular summary index.

from $Splunk_Home/etc/apps and $Splunk_Home/etc/users (for private searches)

grep -Hir "action.summary_index._name\s*=\s*<your summary index name here>" | grep savedsearches.conf

This would give you list of savedsearches.conf which contains the searches (which you need to open manually).

[deepak02]

Works 🙂

Awarded points for the additional info provided.

[rphillips_splk · Accepted solution]

@deepak02 you can use the REST api endpoint for saved searches and look for those which have summary indexing enabled:

run this search:
| rest /servicesNS/-/-/saved/searches | search action.summary_index=1 | table title qualifiedSearch action.summary_index

[deepak02]

Works beautifully! Thankyou very much