Splunk Search

What is the difference between Event Count and Statistic Count in Splunk search results?

sarfaraz1089
Engager

In Splunk search results, what is the difference between events count and statistic count. (I am unable to upload the image of the search result as my karma scoreis less than 60.)

Tags (4)

strive
Influencer

Events tab:

It displays the plain events present in the index.

For Example: Say you write a search as index=myindex earliest=-1d@d latest=-0d@d For this, the Events Tab lists all the events present in the index myindex for previous day.

Note: Here myindex can be a raw index or a summary index.

For the above search, the Statistics tab doesn't display any reporting data since you have not used any reporting commands. The Statistics tab will contain a message: "Your search isn't generating any statistic or visualization results. Here are some possible ways to get results."

Statistics tab:

This tab depicts search results as report result tables. For the same search that is used in the Events tab example, if we add some reporting search command, say for example: index=myindex earliest=-1d@d latest=-0d@d | stats count as Count by ClientIP then the Statistics tab contains data for this search with two columns ClientIP and Count.

Assume that your index has 1000 log events and the unique ClientIP count in those 1000 log lines is 10. Then the Events tab will contain 1000 entries and the tab heading will be Events(1000), the Statistics tab will contain 10 entries and the tab heading will be Statistics(10)

One more point is: whether data gets displayed under Events tab or not depends on the search mode.
For more details read this http://docs.splunk.com/Documentation/Splunk/6.1.3/Search/Changethesearchmode

strive
Influencer

Upload the image to some third party website and provide the link.

I guess you are asking about the Events and Statistics tabs of Search Assistant. Assuming this, i will answer your question.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...