Splunk Search

How to extract field names from an object or nested JSON field?

SwervyMcBourbon
Engager

For these following two events:

 

 

{
  "people": {
    "bob": 172,
    "maria": 161
  }
}

{
  "people": {
    "bob": 172,
    "garth": 180
  }
}

 

 

 
I want to report the number of occurrences of each person's name in the "people" object (the field name itself, not its value).  The desired result of my query against the two events above would be:

 

 

bob: 2
maria: 1
garth: 1

 

 

 

What SPL syntax/commands could I use to achieve this?  I have tried a variety of things online to no avail.

 

 

Labels (5)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

See if this helps.

<<your search for people events>>
| spath
```Loop over the people object and make a list of each name found```
| foreach people.* [ eval name=mvappend(name,if(isnotnull('<<FIELD>>'),"<<MATCHSTR>>", null()))]
```Break the name list into separate events```
| mvexpand name
```Count the names```
| stats count by name
---
If this reply helps you, Karma would be appreciated.

View solution in original post

SwervyMcBourbon
Engager

This worked like a charm, thank you @richgalloway !

richgalloway
SplunkTrust
SplunkTrust

See if this helps.

<<your search for people events>>
| spath
```Loop over the people object and make a list of each name found```
| foreach people.* [ eval name=mvappend(name,if(isnotnull('<<FIELD>>'),"<<MATCHSTR>>", null()))]
```Break the name list into separate events```
| mvexpand name
```Count the names```
| stats count by name
---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...

Starting With Observability: OpenTelemetry Best Practices

Tech Talk Starting With Observability: OpenTelemetry Best Practices Tuesday, October 17, 2023   |  11AM PST / ...