Getting Data In

How to parse data for a table to display list

skphi13
New Member

This is what I have when I tried my search query.

INFO: Found installations for 8 accounts [scheduler]
       "accountNames": [
         "MTS",
         "hasc-services",
         "ahchaudhary",
         "reviews",
         "PM-Solutions",
         "traveler",
         "Affiliates",
         "Catalyst"
       ],
       "accountCount": 8

I am trying to parse the data to a table to display a list of accountNames only.

Any help would be appreciated.

0 Karma

evania
Splunk Employee
Splunk Employee

Hi @skphi13 ,

Did you have a chance to check out an answer? If it worked, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help you.

Thanks for posting!

0 Karma

omuelle1
Communicator

I would recommend creating a field to extract the data using a regex:

Something like:

| rex field=_raw max_match=0 "\"(?.*)\""

0 Karma
Get Updates on the Splunk Community!

App Platform's 2025 Year in Review: A Year of Innovation, Growth, and Community

As we step into 2026, it’s the perfect moment to reflect on what an extraordinary year 2025 was for the Splunk ...

Operationalizing Entity Risk Score with Enterprise Security 8.3+

Overview Enterprise Security 8.3 introduces a powerful new feature called “Entity Risk Scoring” (ERS) for ...

Unlock Database Monitoring with Splunk Observability Cloud

  In today’s fast-paced digital landscape, even minor database slowdowns can disrupt user experiences and ...