Splunk Json extraction - single and multiple items...

Splunk Search

Hi,

New to splunk first time lister. Hoping for some help.

I am trying to extract nested JSON data from a Widows Event log message in splunk. This works (up to a point):

index="someindex" host="Ahost1" | spath input=Message

Its great, except one the of the Json fields is called 'JSON_ArrayUsers' containing UPNs of users. Sometimes it contains a single user, sometimes more than one user.

When more than one user Splunk calls the field this:

JSON_ArrayUsers{}

and when just a single user is listed it names the field this:

JSON_ArrayUsers

This makes searching the field difficult as its called two different things. Its there an easy way to stop the {} appearing - i already know its an array!

Thanks,

Pete

Get Updates on the Splunk Community!

Vibe-coding, AI, and Splunkcraft: Highlights from the .conf26 Builder Bar

If you stopped by the Builder Bar at .conf26, thank you! This year, we brought ...

Thanks for the Memories: .conf26 Took Learning to New Heights

Thank you, Splunk Community, for making .conf26 in Denver one for the books. From packed Splunk University ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...