Splunk Search

How to create a dashboard that will calculate searches per minute on each search head?

sravankaripe
Communicator

We have X-numbers of search heads. i want to create a dashboard which will calculate searches per minute on each Splunk search head. So please help me with the search query.

0 Karma
1 Solution

dkeck
Influencer

Hallo,

maybe try this

index=_audit action="search" search="*" NOT user="splunk-system-user" savedsearch_name="" NOT search="\'|history*" NOT search="\'typeahead*" | timechart span=1m count by host

But take care about the span 1m is maybe to much and could end in "The specified span would result in too many (>50000) rows."

Pls note this will exclude saved searches

You can also exculde summary searches by adding NOT search="'summarize*"

Kind Regards

View solution in original post

0 Karma

dkeck
Influencer

Hallo,

maybe try this

index=_audit action="search" search="*" NOT user="splunk-system-user" savedsearch_name="" NOT search="\'|history*" NOT search="\'typeahead*" | timechart span=1m count by host

But take care about the span 1m is maybe to much and could end in "The specified span would result in too many (>50000) rows."

Pls note this will exclude saved searches

You can also exculde summary searches by adding NOT search="'summarize*"

Kind Regards

0 Karma
Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...