Splunk Search

how to get items from a large json file?

cleal
New Member

Hi everyone

I´m new in splunk ,I need to get items from a json file but when i search in my file i see this in many parts and i don´t get all entities that i need.

How can i configure splunk to read json in only one event and so i can to get all entities ?

On image i have 3 events from same json file i need only one event and so get all entities from this json .

alt text

Tags (1)
0 Karma

woodcock
Esteemed Legend

The general answer is to add | spath to your search and go from there. That command has many options and you can call it multiple times with filtering and renaming steps between:

http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Spath

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 ...