RE: OEM 12c Information Publisher

From: Le, Binh T. <Binh.Le_at_lfg.com>
Date: Thu, 1 Jun 2017 19:12:27 +0000
Message-ID: <BL2PR08MB4685373EE1CA00E4A205DE5F2F60_at_BL2PR08MB468.namprd08.prod.outlook.com>

Use this as the starting point … you’ve got the idea how to get all combination that you want via mgmt$target_properties view.

SELECT t.host_name AS host
, ip.property_value IP
, t.target_name AS name
, DECODE ( t.type_qualifier4 , ' ' , 'Normal' , t.type_qualifier4 ) AS type
, dbv.property_value AS version
, port.property_value port
, SID.property_value SID
, logmode.property_value AS "Log Mode"
, oh.property_value AS "Oracle Home"
FROM mgmt$target t
, (

    SELECT p.target_guid
    , p.property_value
    FROM mgmt$target_properties p
    WHERE p.property_name = 'DBVersion'   )
  dbv
, (

    SELECT p.target_guid
    , p.property_value
    FROM mgmt$target_properties p
    WHERE p.property_name = 'Port'
  )
  port
, (

    SELECT p.target_guid
    , p.property_value
    FROM mgmt$target_properties p
    WHERE p.property_name = 'SID'
  )
  sid
, (

    SELECT p.target_guid
    , p.property_value
    FROM mgmt$target_properties p
    WHERE p.property_name = 'log_archive_mode'   )
  logmode
, (

    SELECT p.target_guid
    , p.property_value
    FROM mgmt$target_properties p
    WHERE p.property_name = 'OracleHome'   )
  oh
, (

    SELECT tp.target_name AS host_name
    , tp.property_value
    FROM mgmt$target_properties tp
    WHERE tp.target_type = 'host'
    AND tp.property_name = 'IP_address'   )
  ip

WHERE t.target_guid     = port.target_guid
AND port.target_guid    = sid.target_guid
AND sid.target_guid     = dbv.target_guid
AND dbv.target_guid     = logmode.target_guid
AND logmode.target_guid = oh.target_guid
AND t.host_name         = ip.host_name

ORDER BY 3,1; From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nagaraj chk Sent: Thursday, June 01, 2017 1:40 PM
To: oracle-l <oracle-l_at_freelists.org> Subject: OEM 12c Information Publisher

***This email is from an external source. Only open links and attachments from a Trusted Sender.*** Dear Gurus,

I haven’t investigated information publisher reports that are already available to sysman user in OEM 12c, I am looking for a report with database name,version,oracle home path and listener port in a single page. If you have any such custom queries please share with me.

-Naga
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 01 2017 - 21:12:27 CEST