This discussion is archived
1 Reply Latest reply: Dec 10, 2012 1:36 AM by 856777 RSS

OEM agent status information

856777 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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');

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points