Getting Data In

different results searching json data depending on app

fdarrigo
Path Finder

alt textI am ingesting JSON data via the HEC on a HeavyForwarder, but when I query the data in SplunkCloud, I have different results depending on which app I am using to query the data.

For example, in the search and reporting app, the json data creates an event with fields "ping.jitter" and "ping.latency". However, when I query using a custom app, the event is not created and the fields "ping.jitter" and "ping.latency" are not created nor are they populated with data.
alt text
Any ideas why?

Tags (1)
0 Karma
1 Solution

MuS
Legend

Hi fdarrigo,

Two possible reasons:

  1. You run the search in your custom app in fast mode, see https://docs.splunk.com/Documentation/Splunk/latest/Search/Changethesearchmode#Using_the_Fast_mode for more details
  2. You need to add KV_MODE = json to your sourcetype under Setting - Source types in your custom app

Hope this helps ...

cheers, MuS

View solution in original post

0 Karma

fdarrigo
Path Finder

MuS- Changing from fast mode to verbose solved the problem
anthonymelita - thanks for the tip. I will keep it in mind.

0 Karma

MuS
Legend

Hi fdarrigo,

Two possible reasons:

  1. You run the search in your custom app in fast mode, see https://docs.splunk.com/Documentation/Splunk/latest/Search/Changethesearchmode#Using_the_Fast_mode for more details
  2. You need to add KV_MODE = json to your sourcetype under Setting - Source types in your custom app

Hope this helps ...

cheers, MuS

0 Karma

anthonymelita
Contributor

In my experience Splunk attempts to auto-extract json objects to fields and frequently fails. Try adding an |spath command as your first pipe after basic search criteria like index, source, etc...

0 Karma

fdarrigo
Path Finder

Thanks. I will keep it in mind.

0 Karma
Get Updates on the Splunk Community!

The Payment Operations Wake-Up Call: Why Financial Institutions Can't Afford ...

The same scenario plays out across financial institutions daily. A payment system fails at 11:30 AM on a busy ...

Make Your Case: A Ready-to-Send Letter for Getting Approval to Attend .conf25

Hello Splunkers, Want to attend .conf25 in Boston this year but not sure how to convince your manager? We've ...

Community Spotlight: A Splunk Expert's Journey

In the world of data analytics, some journeys leave a lasting impact not only on the individual but on the ...