topic Re: How to retrieve the correct populating for different choice values in dropdown box in Dashboards & Visualizations

How to retrieve the correct populating for different choice values in dropdown box

edwinmae — Fri, 01 Apr 2016 12:21:42 GMT

We have 2 Data Centers: US and UK
Let's say we have 10 servers per Data Center

Now when I use the 'setup' below, I am able to retrieve all the servers and all the US servers as the US servers have the letter 'C' in their hostname. Unfortunately the servers in the US don't have a letter or something else that clearly differentiates them from the UK servers.

The only logical way would be to sort them on bases of the IP address (as US and UK have different IP ranges). Unfortunately I didn't succeed with that and I am bit stucked. (although the populating query gives me, however, the hostnames and IP addresses)

Is there a way to have the choice values, using IP Addresses and/or using some search per choice value?

<fieldset submitButton="true" autoRun="true">
    <input type="dropdown" token="sourceHost">
      <label>Data Center</label>
      <choice value="*?*">UK</choice>
      <choice value="*C*">US</choice>
      <choice value="*">ALL</choice>
      <populatingSearch fieldForLabel="ALL" fieldForValue="*">index=_internal source=*metrics.log group=tcpin_connections   | eval sourceHost=if(isnull(hostname), sourceHost,hostname)   | fields sourceIp sourceHost | table sourceHost sourceIp</populatingSearch>

Thanks in advance for any help with this!

Re: How to retrieve the correct populating for different choice values in dropdown box

somesoni2 — Fri, 01 Apr 2016 16:23:51 GMT

Try something like this

Assuming the value is to be used with field hostname (hostname=$sourceHost$)

 <fieldset submitButton="true" autoRun="true">
     <input type="dropdown" token="sourceHost">
       <label>Data Center</label>
       <choice value="NOT hostname=*C*">UK</choice>
       <choice value="hostname=*C*">US</choice>
       <choice value="hostname=*">ALL</choice>
       <default>ALL</default>
       <populatingSearch fieldForLabel="sourceHostVal" fieldForValue="sourceHost">index=_internal source=*metrics.log group=tcpin_connections   | eval sourceHost=if(isnull(hostname), sourceHost,hostname)   | stats count by sourceHost | table sourceHost | eval sourceHostVal="hostname=".sourceHost </populatingSearch>

Re: How to retrieve the correct populating for different choice values in dropdown box

edwinmae — Mon, 04 Apr 2016 06:54:33 GMT

-- It sounded too good to be true --

1
I have one dashboard where I retrieve all the servers separately -- that works fine

 Populating search:   index="perfmon" | dedup host

2
For the second dashboard I want to have 3 groups:
1) all servers for the UK
2) all servers for the US
3) all the servers for the UK and the US.

This means that I only want to see UK, US and ALL in the drop-down box and not the individual servers. My current setup works for 3) ALL and 2) the US, but not for the UK as explained in my first mail.

In your setup I get the individual servers listed in the drop-down box (as well) and neither the UK, US and ALL works (anymore). Also the individual servers don't work

Error in 'search' command: Unable to parse the search: Comparator '=' has an invalid term on the left hand side.

I tried different combinations but in the end the US and ALL throw the above 'Error' and UK says No results found.

I like the idea of listing all servers that don't have a the letter 'C' in the hostname as it should probably be the easiest way, assuming it's possible somehow to use NOT or !=

Please advise

Re: How to retrieve the correct populating for different choice values in dropdown box

edwinmae — Mon, 04 Apr 2016 10:57:27 GMT

I am version using 6.1