Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Dashboards & Visualizations
×
Are you a member of the Splunk Community?
Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Find Answers
- :
- Using Splunk
- :
- Dashboards & Visualizations
- :
- Re: How to split token value and search new values...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
baty0
Explorer
09-13-2018
12:07 AM
Hi,
On a dashboard, in a text field box, I would like to be able to give a list of servers in the following format:
server1,server2,server3,server4 etc...
Is it possible to split this list, do a search on a lookuptable and return information for these servers?
For example, the search would be:
|inputlookup ServerInfo.csv
|search HostName=server1 OR HostName=server2 OR HostName=server3 OR HostName=server4
I hope that makes sense
Thanks
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
renjith_nair
Legend
09-13-2018
12:29 AM
@baty0 ,
Try below. You need to change the html panel to adapt your dashboard panels.
<form>
<label>Token Split</label>
<fieldset submitButton="false">
<input type="text" token="server_names">
<label>Server Name</label>
<change>
<eval token="splitted_search">"(hostname=\"".mvjoin(split(replace($value$," ",""),","),"\" OR hostname=\"")."\")"</eval>
</change>
</input>
</fieldset>
<row>
<html>
<h1>|inputlookup ServerInfo.csv|search $splitted_search$</h1>
</html>
</row>
</form>
---
What goes around comes around. If it helps, hit it with Karma 🙂
What goes around comes around. If it helps, hit it with Karma 🙂
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
renjith_nair
Legend
09-13-2018
12:29 AM
@baty0 ,
Try below. You need to change the html panel to adapt your dashboard panels.
<form>
<label>Token Split</label>
<fieldset submitButton="false">
<input type="text" token="server_names">
<label>Server Name</label>
<change>
<eval token="splitted_search">"(hostname=\"".mvjoin(split(replace($value$," ",""),","),"\" OR hostname=\"")."\")"</eval>
</change>
</input>
</fieldset>
<row>
<html>
<h1>|inputlookup ServerInfo.csv|search $splitted_search$</h1>
</html>
</row>
</form>
---
What goes around comes around. If it helps, hit it with Karma 🙂
What goes around comes around. If it helps, hit it with Karma 🙂
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
baty0
Explorer
09-13-2018
12:55 AM
Thanks you so much for your answer, that worked!
I have one last question.
Would it be possible to detect if there is a space between the server name and make the search still work.
For example:
server1, server2, server3, server4
Thank you
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
renjith_nair
Legend
09-13-2018
01:28 AM
you shall remove the space, Please use below
"(hostname=\"".mvjoin(split(replace($value$," ",""),","),"\" OR hostname=\"")."\")"
Updated the answer with the change. Please upvote if it helps!
---
What goes around comes around. If it helps, hit it with Karma 🙂
What goes around comes around. If it helps, hit it with Karma 🙂
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
baty0
Explorer
09-13-2018
04:41 PM
You're a legend! Thanks
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!
Community Content Calendar, September edition
Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...
Splunkbase Unveils New App Listing Management Public Preview
Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...
Leveraging Automated Threat Analysis Across the Splunk Ecosystem
Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...
