Splunk Search

Is there a way I can hard-code a drop-down search to display all virtual machines on my network?

Path Finder

Hello people,

Is there a way I can hard-code a drop-down search to display all virtual machines in my network on the drop-down? Without getting the duplicating errors all the time :

Sample of my xml query below:

<form>
  <label>Z_</label>
  <fieldset submitButton="true">
    <input type="dropdown" token="vmname" searchWhenChanged="false">
      <label>host_name</label>
       <query>index=* collection="*" counter=*  collection=LogicalDisk counter="Avg. Disk Queue Length" eventtype=perfmon_logicaldisk  Host="*"  instance=_Total Host=$vmname$  | timechart useother=f minspan=1s avg(Value) AS avg_Disk_Que_Len by host | eval avg_Disk_Que_Len = round(avg_Disk_Que_Len,1) | sort +avg_Disk_Que_Len</query>
0 Karma
1 Solution

SplunkTrust
SplunkTrust

Hi idab,

I think you mix up something here: you are not hard coding your hosts here, this is a dynamic drop down.
Nevertheless to remove the duplicate error, simply to this in your populating search :

index=* collection="*" counter=*  collection=LogicalDisk counter="Avg. Disk Queue Length" eventtype=perfmon_logicaldisk  Host="*"  | dedup Host

Hope this helps ...

cheers, MuS

View solution in original post

SplunkTrust
SplunkTrust

Hi idab,

I think you mix up something here: you are not hard coding your hosts here, this is a dynamic drop down.
Nevertheless to remove the duplicate error, simply to this in your populating search :

index=* collection="*" counter=*  collection=LogicalDisk counter="Avg. Disk Queue Length" eventtype=perfmon_logicaldisk  Host="*"  | dedup Host

Hope this helps ...

cheers, MuS

View solution in original post

Path Finder

Hi MuS,

I tried what you mentioned above - it didn't solve the problem.See below a sample of what i did so far

Z_

<input type="dropdown" token="vmname" searchWhenChanged="false">
  <label>host_name</label>
  <search>
    <query>index=main collection="*" counter=*  collection=LogicalDisk  eventtype=perfmon_logicaldisk  Host="*"  | dedup Host</query>
  </search>
  <fieldForLabel>name</fieldForLabel>
  <fieldForValue>name</fieldForValue>
  <choice value="*">All</choice>
  <default>*</default>
</input>
<input type="time" searchWhenChanged="true">
  <label></label>
  <default>
    <earliest>-4h@m</earliest>
    <latest>now</latest>
  </default>
</input>
0 Karma

SplunkTrust
SplunkTrust

is this the correct field?

<fieldForLabel>name</fieldForLabel>
<fieldForValue>name</fieldForValue>

If so, use this populating search:

index=main collection="*" counter=*  collection=LogicalDisk  eventtype=perfmon_logicaldisk  Host="*"  | dedup name | table name

If this still not works, use the Host field as fieldForLabel and fieldForValue

Path Finder

Thanks..MuS. The host field was the problem.
Good job!

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!