Skip to main content

MTTR Report

  • September 22, 2025
  • 1 reply
  • 0 views
J

We need to retrieve the total number of alerts along with the Mean Time To Resolve (MTTR) and Mean Time To Acknowledge (MTTA) for those alerts. I have not been able to find a suitable dashboard or report for this. Could you please advise on how to obtain this information?

1 reply

J

If you have a look in this table, you will see when date time stamps which might help you do some calculations 

select *  from master_events.events_cleared limit 10

for example, there is a Date_first, for when the event first occurred and Date_last when it had finished. 

 

Active events are in a different table: select *  from master_events.events_active limit 10

    Terms & ConditionsAccessibility statement