Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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 You also can run  run the following query to get the configuration ID of the monitor you want to check:

Code Block
languagesql
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:

Code Block
languagesql
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

...

  1. Click Tools, then Internet Options.
  2. Click the Privacy tab.
  3. Click Advanced.
  4. Select the Override automatic cookie handling check box.
  5. For Third-party Cookies, select the Accept option.
  6. Click Done.

Related Documentation:

...