Splunk Search

Can I use wildcards in the lookup csv file to show a list of similar named servers?

New Member

I'm using a lookup table to further define the type of servers listed in a drop down box. The csv file is manually created, so I would like to use wildcards to specify my search criteria.

us6pb1d01,"SAP BW (PB1)",db,ccr_nmon
us6pb1a01,"SAP BW (PB1)",app,ccr_nmon
us6pb1a02,"SAP BW (PB1)",app,ccr_nmon
us6pwmd01,"WebMethods (PWM)",db,ccr_nmon
us6pwmd02,"WebMethods (PWM)",db,ccr_nmon

us6pb1d*,"SAP BW (PB1)",db,ccr_nmon
us6pb1a*,"SAP BW (PB1)",app,ccr_nmon
us6pwmd*,"WebMethods (PWM)",db,ccr_nmon

I have the following in my transforms.conf file:

filename = ccr_serverlookup.csv
match_type = WILDCARD(servertype)

However, when I go to select a server, it is listing "us6pwmd*" and not giving a list of servers.

Here are parts of my input criteria:

  <populatingSearch earliest="$timerange.earliest$" latest="$timerange.latest$" fieldForLabel="landscape" fieldForValue="landscape">| inputlookup ccr_serverlookup.csv | fields landscape | dedup landscape | table landscape</populatingSearch>
<input type="dropdown" token="servertype" searchWhenChanged="true">
  <label>Server Type:</label>
  <choice value="*">All</choice>
  <choice value="app">Application</choice>
  <choice value="db">Database</choice>
<input type="multiselect" token="hostname" searchWhenChanged="true">
  <label>Hosts Selection:</label>
  <populatingSearch earliest="$timerange.earliest$" latest="$timerange.latest$" fieldForLabel="hostname" fieldForValue="hostname">|inputlookup ccr_serverlookup.csv | where landscape="$landscape$" AND servertype="$servertype$" | stats count by hostname | dedup hostname | sort hostname

Any suggestions??

Many thanks!

Tags (2)
0 Karma


is it working?

0 Karma


Add * front and back of your token based on your req like server type

inputlookup ccr_serverlookup.csv | where landscape="$landscape$" AND servertype="*$servertype$*" | stats count by hostname | dedup hostname | sort hostname
Get Updates on the Splunk Community!

What’s new on Splunk Lantern in August

This month’s Splunk Lantern update gives you the low-down on all of the articles we’ve published over the past ...

Welcome to the Future of Data Search & Exploration

You have more data coming at you than ever before. Over the next five years, the total amount of digital data ...

This Week's Community Digest - Splunk Community Happenings [8.3.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...