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

Compare with Current View Page History

Version 1 Next »

Run the following query to get the configuration ID of the monitor you want to check:

\n
\n

SELECT configuration_id from erdc_instance

\n

WHERE name <name of the monitor>;

\n

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

\n
\n

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