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!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...