Splunk Search

Counting Your searches

carmackd
Communicator

Is there anyway to count the number of searches ran on an indexer in a 24 hour period?

Tags (2)
0 Karma
2 Solutions

ftk
Motivator

The following gives you a total for all adhoc searches run in the past 24 hours:

index=_internal sourcetype="searches" earliest=-24h | stats count

And this one will give you a total for all searches, including saved searches run in the past 24 hours:

index=_internal (sourcetype="searches" OR SavedSplunker) earliest=-24h | stats count

And individual counts by user:

index=_internal (sourcetype="searches" OR SavedSplunker) earliest=-24h | stats count by user

View solution in original post

hulahoop
Splunk Employee
Splunk Employee

In the Search App in the Status > Search activity dashboards in Splunk 4.1.x there are dashboards containing the following searches:

Search load over time (last 24 hours)
Search count by user (last 24 hours)
Run time by user (last 24 hours)
Common searches (last hour)
CPU Utilization due to searches
etc.

If you have SplunkWeb running on the indexer these dashboards will display results for that indexer. I'm not sure if these dashboards are built out of the box for distributed search though.

View solution in original post

hulahoop
Splunk Employee
Splunk Employee

In the Search App in the Status > Search activity dashboards in Splunk 4.1.x there are dashboards containing the following searches:

Search load over time (last 24 hours)
Search count by user (last 24 hours)
Run time by user (last 24 hours)
Common searches (last hour)
CPU Utilization due to searches
etc.

If you have SplunkWeb running on the indexer these dashboards will display results for that indexer. I'm not sure if these dashboards are built out of the box for distributed search though.

ftk
Motivator

The following gives you a total for all adhoc searches run in the past 24 hours:

index=_internal sourcetype="searches" earliest=-24h | stats count

And this one will give you a total for all searches, including saved searches run in the past 24 hours:

index=_internal (sourcetype="searches" OR SavedSplunker) earliest=-24h | stats count

And individual counts by user:

index=_internal (sourcetype="searches" OR SavedSplunker) earliest=-24h | stats count by user
Get Updates on the Splunk Community!

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...