topic Re: View Summary Index query in Splunk Search

View Summary Index query

deepak02 — Tue, 16 May 2017 16:16:52 GMT

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.

Re: View Summary Index query

rphillips_splk — Tue, 29 Sep 2020 14:05:31 GMT

@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

Re: View Summary Index query

somesoni2 — Tue, 29 Sep 2020 14:05:37 GMT

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).

Re: View Summary Index query

deepak02 — Tue, 16 May 2017 18:18:01 GMT

Works 🙂

Awarded points for the additional info provided.

Re: View Summary Index query

deepak02 — Tue, 16 May 2017 18:54:17 GMT

Works beautifully! Thankyou very much