Re: OEM 12c Information Publisher

Awesome thank you so much, *Le Binh. *It was really helpful

On Fri, Jun 2, 2017 at 12:42 AM, Le, Binh T. <Binh.Le_at_lfg.com> wrote:

> 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