topic Re: help on a dropdown list static option for empty field in Dashboards & Visualizations

help on a dropdown list static option for empty field

jip31 — Tue, 03 Sep 2019 08:21:54 GMT

Then, I use the search below in order to be able to filter the search results by SITE
it works, but I also want to be able to display the hosts from host.csv which have no SITE in toto.csv because sometimes this field is empty
what I have to add in the static option to do this please?

| inputlookup host.csv 
| lookup patchlevel.csv "Computer" as host 
| lookup toto.csv HOSTNAME as host output SITE 
| search SITE=$tok_filtersite|s$ 
| stats count(flag_patch_version)

thanks

Re: help on a dropdown list static option for empty field

KARANMALHOTRA — Tue, 03 Sep 2019 12:41:03 GMT

You can use fillnull to assign a dummy SITE value (like blank) to the output after the lookup with the toto.csv file.

And then add a static N/A value to your first filter. So when you select blank in the filter, the search will consider all hosts without SITE.

| inputlookup host.csv 
| lookup patchlevel.csv "Computer" as host 
| lookup toto.csv HOSTNAME as host output SITE 
| fillnull SITE value="blank"
| search SITE=$tok_filtersite|s$ 
| stats count(flag_patch_version)

see fillnull documentation here

Re: help on a dropdown list static option for empty field

jip31 — Tue, 03 Sep 2019 12:56:14 GMT

thanks for your answer