Splunk Search

Datamodel tstats search and normal search result is not same

Path Finder


I run two splunk search and results not come same.

In the first search is with tstats ;

timeprefix = yesterday

| tstats `summariesonly` count from datamodel=Authentication.Authentication where index=wineventlog Authentication.user=some_user

result is = 8990

In the second search ;

index=wineventlog  user=some_user tag=authentication NOT (action=success user=*$)| stats count

result is = 9000


Why datamodel and normal splunk search result is different ? 

Also ;

Datamodel accelaration status is %99 ? 

Could the problem be caused by this?


Thank you.

Labels (2)
0 Karma


The summariesonly option tells tstats to look only at events that are in the accelerated datamodel.  If the DMA is not complete then the results also will not be complete.

If this reply helps you, Karma would be appreciated.
0 Karma

Path Finder

My DMA is never been %100. it's generally %99.x . Why is this happening ? 

How ı find the problem ? 

0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...