Hi
I am trying to write SQL that will collect how much time each alarm (that got triggered) took to get resolved ( time difference between time of when it got triggered and time of when it got resolved)
Basically I am trying to get table like this
Alarm_id | Alarm_message | Time it got Triggered |Time it got Resolved Age ( difference between two times) |
Can you please help me with SQL ?
I did spent time looking at Alarm and Alarm_events tables, but I could not frame correct query
I am trying to write SQL that will collect how much time each alarm (that got triggered) took to get resolved ( time difference between time of when it got triggered and time of when it got resolved)
Basically I am trying to get table like this
Alarm_id | Alarm_message | Time it got Triggered |Time it got Resolved Age ( difference between two times) |
Can you please help me with SQL ?
I did spent time looking at Alarm and Alarm_events tables, but I could not frame correct query