Splunk Search

What can be the query so that i can display the field " API.V1.WEBS_ENTITLED_PRODUCTS" and not its value?

payyachamy
Observer

I have the logs in this way :

   measures: { 
     API.V1.WEBS_ENTITLED_PRODUCTS296
     success300

   }

what can be the query so that i can display the field " API.V1.WEBS_ENTITLED_PRODUCTS" and not its value.

I want the output as  "API.V1.WEBS_ENTITLED_PRODUCTS"

Labels (4)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @payyachamy,

you could use a regex like the following:

your_search
| rex "measures:\s+\{\s+(?<your_field>[^:]+)"

that you can test at https://regex101.com/r/0uOTvQ/1

Ciao.

Giuseppe

0 Karma

payyachamy
Observer
your_search
| rex "measures:\s+\{\s+(?<your_field>[^:]+)"

but the issue with this query is this particular field keeps on changing,  so the query should be dynamic to pick the field which is coming in.

 

0 Karma

PickleRick
SplunkTrust
SplunkTrust

And what would be the criteria for selecting this particular event? Do you have this field parsed out of the event?

0 Karma

payyachamy
Observer

measures: { 
     API.V1.WEBS_ENTITLED_PRODUCTS296
     success300

   }

   metadata: { 
     downlink10
     effectiveType4g

   }

   name: WIDGET_LOAD.PIU

the thing here is I need a query which shows the API that is responsible for a widget load.

so I need a table which shows : 

WIDGET.                           |                      API

-------------------------------------------------------------------       

WIDGET_LOAD.PIU     |.       API.V1.WEBS_ENTITLED_PRODUCTS

0 Karma

PickleRick
SplunkTrust
SplunkTrust

Unfortunately, splunk has very limited event-level introspection capacities so you have to parse out the field name from the raw event on your own. If your event structure is relatively strict, it should be possible with regexes similarily to what @gcusello showed.

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...