I can do this search | metadata type=hosts | convert timeformat="%m/%d/%Y - %H:%M:%S" ctime(*Time)
This will give me the date fields of first, last and recent Time.
I want to Pipe to an if statement to see if the recent or last time is between yesterday and 14 days ago and report on only those servers.
If a server has not been reporting in 14 days it is most likely off the network for good.
How do I correct the syntax for | eval not_reporting=case(lastTime>yesterday, alert, lastTime<30days_ago, alert)
Any help with syntax would be great.
... View more