Splunk Search

Datamodel tstats search and normal search result is not same

burakatabay
Path Finder

Hi,

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

richgalloway
SplunkTrust
SplunkTrust

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

burakatabay
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!

September Community Champions: A Shoutout to Our Contributors!

As we close the books on another fantastic month, we want to take a moment to celebrate the people who are the ...

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...