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!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...