Help for diisplay a message in a single panel following a token value

[jip31]

HI

I use the code below and I would like that if the host I fill in my drilldown doenst exists J have the message "No Battery results" in my single panel

Could you help me please??

| inputlookup tablet_host.csv 
| lookup Pan.csv "Hostname00" as host OUTPUT HealthState00 
| search host=$tok_filterhost$ 
| stats values(HealthState00) as HS 

I 

[gcusello]

Hi @jip31,

try something like this:

| inputlookup tablet_host.csv 
| lookup Pan.csv "Hostname00" as host OUTPUT HealthState00 
| search host=$tok_filterhost$ 
| stats values(HealthState00) as HS 
| append [ | makeresults | eval HealthState00="No Battery result" | fields HealthState00 ]

Ciao.

Giuseppe

[gcusello]

Hi @jip31,

I was wrong, please check this:

| inputlookup tablet_host.csv 
| lookup Pan.csv "Hostname00" as host OUTPUT HealthState00 
| search host=$tok_filterhost$ 
| stats values(HealthState00) as HS 
| append [ | makeresults | eval HS="No Battery result" | fields HS ]
| table HS

Ciao.

Giuseppe

[jip31]

Hi

it doesnt works

If the token value is not good, I have 0% instead "No Battery result"