1 Reply Latest reply: Dec 10, 2012 3:36 AM by 856777 RSS

    OEM agent status information

    856777
      How to find current Target status , Up since,Instance Name,Host information from which tables in OEM backend..

      Please let me know.
        • 1. Re: OEM agent status information
          856777
          My self prepared below query..

          /* Formatted on 2012/12/07 16:21 (Formatter Plus v4.8.8) */
          SELECT mt.target_name,
          DECODE (mt.display_name,

          'PROD', 'EBS-PROD',
          mt.display_name
          ) instance_name,
          mt.host_name,
          DECODE (mca.current_status,

          '1', 'UP',
          '0', 'DOWN',
          '2', 'TARGET-UNKNOWN',
          '3', 'UN-MONITORIED',
          '4', 'UNREACHABLE',
          '5', 'BLOCKOUT-STATE',
          '6', 'UNKNOWN-STATE',
          mca.current_status
          ) status
          FROM mgmt_targets mt, mgmt_current_availability mca
          WHERE mt.target_guid = mca.target_guid
          AND mt.target_name IN
          ('PROD');