Splunk Search

Select the right index based on value in Dropdown

sandmountain
Explorer

I have a dropdown with two values PROD and TEST. Based on my selection in my panels in the dashboard I have to choose a different index for my search. How can I do this?

Example of two searches: (which also includes other tokens. These can be ignored. Both searches work if I directly put in the right index

1/ 
index=<IF PROD then AAA_prod_index else AAA_test_index> sourcetype IN (abc:edge:api, abc:edge:api)  proxy!="ow*" $client_token$ $target_token$ |
rex mode=sed field=proxy "s#^(.*?)_(.*)$#*_\2#" | stats count by proxy

2/
index=<IF PROD then BBB_prod_index else BBB_test_index> sourcetype=accesslog  tenant=$tenant_token$ | stats count by HTTPStatusCode

Labels (3)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

Your dropdown token, for example

<input type="dropdown" token="environment">
  <label>Environment</label>
  <choice value="prod">PROD</choice>
  <choice value="test">TEST</choice>
</input>
...

and then the searches just use that token

index=AAA_$environment$_index sourcetype IN (abc:edge:api, abc:edge:api)  proxy!="ow*" $client_token$ $target_token$ |
rex mode=sed field=proxy "s#^(.*?)_(.*)$#*_\2#" | stats count by proxy
----
index=BBB_$environment$_index sourcetype=accesslog  tenant=$tenant_token$ | stats count by HTTPStatusCode

View solution in original post

sandmountain
Explorer

Thx that worked fine

0 Karma

bowesmana
SplunkTrust
SplunkTrust

Please mark the answer as a solution for others to benefit from - thanks

0 Karma

bowesmana
SplunkTrust
SplunkTrust

Your dropdown token, for example

<input type="dropdown" token="environment">
  <label>Environment</label>
  <choice value="prod">PROD</choice>
  <choice value="test">TEST</choice>
</input>
...

and then the searches just use that token

index=AAA_$environment$_index sourcetype IN (abc:edge:api, abc:edge:api)  proxy!="ow*" $client_token$ $target_token$ |
rex mode=sed field=proxy "s#^(.*?)_(.*)$#*_\2#" | stats count by proxy
----
index=BBB_$environment$_index sourcetype=accesslog  tenant=$tenant_token$ | stats count by HTTPStatusCode
Get Updates on the Splunk Community!

Index This | What did the zero say to the eight?

June 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

Splunk Observability Cloud's AI Assistant in Action Series: Onboarding New Hires & ...

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

Now Playing: Splunk Education Summer Learning Premieres

It’s premiere season, and Splunk Education is rolling out new releases you won’t want to miss. Whether you’re ...