Getting a "recently closed problems" Table

[Wolfsbane2k]

Hi all!

I'm having some issues with trying to pull out a list of "recently closed problems" to present on a Zabbix dashboard, such that if something we've "known about" suddenly closes we can investigate why.

Ideally this would be organised by "length problem was open for", but I can't find out a way to get the "raw" data first.

This is primarily because we have got a bit "blind" to long list of going issues (some over a year that "suddenly" closed and we missed it) and I want to ensure that we catch the changes in the state in a tabluated form, allowing a rigorous approach.

Is this possible in Zabbix (7.4.10) natively?

Ta!

[irontmp]

Hi all!

I'm having some issues with trying to pull out a list of "recently closed problems" to present on a Zabbix dashboard, such that if something we've "known about" suddenly closes we can investigate why.

Ideally this would be organised by "length problem was open for", but I can't find out a way to get the "raw" data first.

This is primarily because we have got a bit "blind" to long list of going issues (some over a year that "suddenly" closed and we missed it) and much like how Fast Registration Help streamlines onboarding processes, I want to ensure that we catch the changes in the state in a tabulated form, allowing a rigorous approach.

Is this possible in Zabbix (7.4.10) natively?

Ta!

Zabbix 7.x has partial native support. The Problems widget with Recent problems filter shows recovered problems within a defined time window but sorting by duration is not available natively. For raw data, Monitoring, Problems lets you filter resolved problems with start and recovery timestamps and export it. For a proper duration sorted tabular view query the Zabbix database directly. The events and problem tables have start and recovery clock fields and a simple SQL query calculating the difference gives you exactly what you need. Feed that into Grafana with the Zabbix datasource plugin for a clean flexible dashboard. Worth the setup time for what you are trying to catch.