| mstats c(System.System_Up_Time) as Uptime prestats=t WHERE index="em_metrics" AND host="*" by host,metric_name span=1m
| where Uptime < (now() - 2160000)
| eval diff=tostring(now() - Uptime,"duration")
| fields host Uptime diff
| sort – Uptime
getting no result
i have 2 hosts one host is coming metric log(System.System_Up_Time) other host is not coming so i want to display it as down
please try line by line.
getting no result
where?
| mstats c(System.System_Up_Time) as Uptime prestats=t WHERE index="em_metrics" AND host="*" by host,metric_name span=1m
| inputlookup append=t hostname.csv
| fillnull Uptime
| where Uptime < (now() - 2160000)
| eval diff=tostring(now() - Uptime,"duration")
| fields host Uptime diff
| sort – Uptime
hostname.csv
host
HostA
HostB
Like This?