Splunk Search

tstats not working on all index time fields?

moneybox
Explorer

I have a python script (requests and post) that sends json events to an Indexer using HTTP Event Collector (HEC).
I can perform searches like

| tstats count where host=XXX by sourcetype
yet I cannot perform tstats searches on fields inside the event, even though they are json fields that are extracted in index time.

How can I make sure a search like

| tstats count where host=XXX by json_field_1
will work ?

Thank you

0 Karma
1 Solution

cpetterborg
SplunkTrust
SplunkTrust

Unless you have the JSON field you want INDEXED, you will not be able to use it in a tstats command. tstats can only work of things that are in the tsidx file (like source, sourcetype, index, host, _time, etc.) and those fields which are indexed (so that means the field extractions would have to be done through the props.conf files on the indexers). If that is not the case in this instance, then you cannot use something like json_field_1 in that search.

View solution in original post

0 Karma

cpetterborg
SplunkTrust
SplunkTrust

Unless you have the JSON field you want INDEXED, you will not be able to use it in a tstats command. tstats can only work of things that are in the tsidx file (like source, sourcetype, index, host, _time, etc.) and those fields which are indexed (so that means the field extractions would have to be done through the props.conf files on the indexers). If that is not the case in this instance, then you cannot use something like json_field_1 in that search.

0 Karma
Get Updates on the Splunk Community!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...