The easiest way to determine the earlier status of a service monitor is by running the "Service Monitor Outage" Report for the Element where the monitor runs.

Or you can run the following query to get the configuration ID of the monitor you want to check:

SELECT configuration_id from erdc_instance
WHERE name <name of the monitor>;

Next, run the following query to see the status of the monitor (ordered by date) and its status message:

SELECT e.name, e.display_name, ei.configuration_id, ei.name, esr.erdc_status_mnemonic, esr.last_transition, est.message
FROM entity e, erdc_instance ei, erdc_configuration ec, erdc_status_retention esr, erdc_status_transition_log est 
WHERE ei.monitored = 1 and ei.configuration_id = <ID from first query> 
AND ei.erdc_status_retention_id = esr.erdc_status_retention_id 
AND ei.entity_id = e.entity_id 
AND est.erdc_instance_id = ei.erdc_instance_id 
AND ec.id = ei.configuration_id 
order by esr.last_transition