My tstats isn't returning results from the other datasets

ebs — Mon, 09 Aug 2021 01:27:22 GMT

Hi,

I have several datasets that have the exact same format with only the source of the data differing. I've duplicated my macros from the dev environment to the test but I'm receiving no results for the test macro, despite when I do the tstats search as a datamodel instead I get results.

Here is the dev search:
tstats summariesonly=true count("dev_metric.exchangeId") as avg_TPS from datamodel=metric by _time, dev_metric.date span=1s
| search "dev_metric.date"=$date$
| stats avg(avg_TPS) as averageTps by dev_metric.date
| eval averageTps=round(averageTps/1000,3)
| appendpipe [tstats count
| where count=0]
| fillnull value=0.000 averageTps
| fields averageTps

Here is the test search:
tstats summariesonly=true count("test_metric.exchangeId") as avg_TPS from datamodel=metric by _time, test_metric.date span=1s
| search "test_metric.date"=$date$
| stats avg(avg_TPS) as averageTps by metric.date
| eval averageTps=round(averageTps/1000,3)
| appendpipe [tstats count
| where count=0]
| fillnull value=0.000 averageTps
| fields averageTps

I've checked the dataset and there are the needed events in there, and I've done a | datamodel search equivalent to tstats that worked fine. What could be the reason I'm receiving no results? And what could be some steps to resolve this?

Re: My tstats isn't returning results from the other datasets

richgalloway — Mon, 09 Aug 2021 12:10:48 GMT

Both searches look only at completed datamodel accelerations. Are both data sets accelerated? Are both accelerations completing successfully?

topic Re: My tstats isn't returning results from the other datasets in Splunk Search

My tstats isn't returning results from the other datasets

Re: My tstats isn't returning results from the other datasets