I need to setup an alert on all search heads if any universal forwarder has not sent data in last 6 or 4 hours. The alerts have to trigger and send an email with output of missing hosts.
I have tried to use this one but it is not working. |metadata type=hosts index=*| table host lastTime | where lastTimerelative_time(now(),"-30d@d")
| convert timeformat="%Y%m%d" ctime(lastTime) AS LastTime