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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...