Check to compare value with csv contents

[davidcraven02]

I'm trying to build a pass/fail check to see if a machine already exists in a csv, as I have a dashboard with a text input where a machine name can be entered.

Below is my search which displays all the machines from the csv, combining them into one line.

[cmerriman · Accepted solution]

try adding something like this:

|eval exists=if(like(machine,"%$token$%"),1,0)

where the token is the dashboard text input

[davidcraven02]

Thank you for this but how would I add a pass or fail to display this?

[cmerriman]

what is your desired output, exactly?

do you just want a dashboard panel that says "pass" or "fail"? if so, add |eval exists=if(like(machine,"%$token$%"),"pass","fail")|table exists and display as a single value, maybe?

[davidcraven02]

Thank you!!!!