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!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...