ParticipantWe 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?
ExpertIf 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
ParticipantThanks James!
"This query is working as expected for smaller data sets. However, when I run it in the database tool, I am unable to retrieve a full month's data. Increasing the LIMIT to 10,000 causes the query to fail, while a smaller limit returns data only for a partial period (from mid-June to the beginning of July). I have attempted to update the query to select data from specific dates, but was unsuccessful.
SELECT * FROM master_events.events_cleared WHERE event_timestamp BETWEEN '2025-08-22' AND '2025-09-22 23:59:59' LIMIT 5000;
Am I doing any mistake?
ExpertRunning large queries is going to be difficult in the gui, as chrome will eventually run out of memory.
you are better off running directly on the db, or using one of the event reports already available, and do your calculations in excel.
