• Created by Unknown User (adimopoulos), last modified by Unknown User (dbranton) on Mar 03, 2014

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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

 

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
  • No labels