Monitoring Splunk

How to do loop on array?

bhanusaketi
Loves-to-Learn

How to loop the array values after split with delimiter 

| eval json="{"key1":"key1value","key2":"key2value","key3":"key3value","key4":"key4Value" }"

| eval keyNames ="key1,key2,key3,key4" // key names can add or remove based on search string the requirement 

 | eval keys=split(keyNames ,";")

How to loop these keys and perform some operation. 

I have tired with some MV commands but no luck.

Example: 

| eval count = mvcount(keys)

| streamstats count as counter

| eval jsonKey= mvindex(keys,count) | eval keyValue = json_extract(json, jsonKey)

I am not sure how to achieve this use case, can some one please help me on it.

 

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

SPL is not a procedural language so there isn't a "loop through" construct per se. However, it depends on what it is you are trying to achieve as to whether there is another way to do it. For example, if you want to simply extract the key-value pairs from the json string use spath

| eval json="{\"key1\":\"key1value\",\"key2\":\"key2value\",\"key3\":\"key3value\",\"key4\":\"key4Value\" }"
| spath input=json
0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...