Zabbix status elapsed time since Problem or OK status
We have a tree of services in our configuration. We are trying to achieve a feature that would show for each service its status and elapsed time since last state change (down to up or up to down). For instance, if the service id down since 5 minutes, we want to see "Down" and "5 min" in the dashboard for this service. Services status are computed using Zabbix specified algorithms, events and alarms that are received and the table status does not keep a timestamp or audit trail to help understanding when the state changed. Thus, knowing the elapsed time since the last threashold (up or down) does not appear to be easy. I'm wondering if we are missing something and if its possible to get that information somewhere. Our thought was to alter the "services" table to add a column that would set a timestamp upon update of rows using a custom trigger. Then, we could use this timestamp and the status to compute the expected value. Would that be a good way of implementing the feature? Is there any other way to show this information?