Folks... I am extracting two variables at search time and trying to report when the two variables are not the same. At this point the two variables are host (coming from the splunk LF running on the system) and os_hostname (coming from a script that calls hostname on a linux box). Basically I want to know when host!=os_hostname and report on that. We have some admins that are cloning servers and forgetting to re-install Splunk so all the cloned systems are reporting as if they were the original cloned system.
I assume there is a way to do this with the Eval command, but can't seem to find the right syntax. Can someone help me?
If you really just want to know when host!=os_hostname, just use
... | where host!=os_hostname
... | eval state=if(host!=os_hostname,"bad","good")
if(lower(host)!=lower(os_hostname),...)
This works GREAT... any way to make it more fuzzy so it doesn't care about capital letters, IE host=computera and os_hostname=COMPUTERA ?