Hi Mike6960,
you need to put your message.information fields in single quotes ' like this:
<my search>
| eval Test =if('message.information'=="some_data",_time,null())
| eval Test2=if('message.information'="some_data_2" ,_time,null())
| eval Test3 = Test - Test2
| table _time Test Test2 Test3
because they contain a . and this is a special case when using eval()
Take a look at this run everywhere SPL:
| makeresults
| eval message.information="1", foo="2"
| eval Test =if('message.information'=="1",now(),null())
| eval Test2=if('message.information'=="2" ,null(),relative_time(now(), "-1sec"))
| eval Test3 = Test - Test2
| table _time Test Test2 Test3
Hope this helps ...
cheers, MuS
... View more