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!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...

Updated Data Management and AWS GDI Inventory in Splunk Observability

We’re making some changes to Data Management and Infrastructure Inventory for AWS. The Data Management page, ...