Hi @yshen , for 1st query , table for alarm , host and durations, you can use below query | makeresults | eval start="2020-08-23T03:04:05.000-0700" | eval end="2020-08-23T03:25:58.000-0700" | eval Agent_hostname="m50-ups.a_domain" | eval alarm="upsAlarmOnBypass" | eval start_epoch=strptime(start,"%Y-%m-%dT%H:%M:%S.000-0700"), end_epoch=strptime(end,"%Y-%m-%dT%H:%M:%S.000-0700") | eval duration_mins = ROUND((end_epoch - start_epoch)/60,2) | table Agent_hostname alarm start end duration For 2nd one, | makeresults | eval start="2020-08-23T03:04:05.000-0700" | eval end="2020-08-23T03:25:58.000-0700" | eval Agent_hostname="m50-ups.a_domain" | eval alarm="upsAlarmOnBypass" | search end!="" | eval start_epoch=strptime(start,"%Y-%m-%dT%H:%M:%S.000-0700"), end_epoch=strptime(end,"%Y-%m-%dT%H:%M:%S.000-0700") | eval duration_mins = ROUND((end_epoch - start_epoch)/60,2) | fields - start_epoch end_epoch _time | table Agent_hostname alarm start end duration_mins | stats max(duration_mins) as max_duration_mins by Agent_hostname,alarm
... View more