Splunk Search

tstats not showing results for Splunk DB Input

siva_cg
Path Finder

I have a Splunk DataBase Input which is sending logs to Splunk by DB Connect app. I am trying to use tstats command on that input but no luck. The query, I am trying is as follows:
|tstats values(field1) values(field2) WHERE index=index1

If I use similar query on normal monitor input, I am getting results. Why I am unable to see for DB Input logs? Any idea? Thanks in advance.

Tags (2)
0 Karma

kmaron
Motivator

Do you have the metadata setup on your DB connect inputs? You need to have that metadata indexed to run tstats.

siva_cg
Path Finder

Hi @kmaron,
Yes, we have defined source, sourcetype and index for the input. I didn't enable any summary_indexing for that particular index.

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

 (view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...