Getting Data In

Why does my tstats search only show results for the main index?

packet_hunter
Contributor
|tstats values(sourcetype) by index

I have 10 indexes, but I only get "main" when I run the search above.

How can I get all my sourcetype(s) by index?

Thanks

Tags (3)
0 Karma
1 Solution

somesoni2
Revered Legend

You need to specify the indexes else, it only shows data from the index set as your "indexes searched by default" in your user/role.

|tstats values(sourcetype) WHERE index=* by index

View solution in original post

somesoni2
Revered Legend

You need to specify the indexes else, it only shows data from the index set as your "indexes searched by default" in your user/role.

|tstats values(sourcetype) WHERE index=* by index
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...