Re: OEM Database Target Host

On Mon, Feb 8, 2016 at 8:19 PM, Courtney Llamas <courtney.llamas_at_oracle.com> wrote:

> You’ll want to select target_type = oracle_database, and get the host_name…
>
>
>
>
>
> Select distinct host_name from mgmt$target where target_type =
> 'oracle_database';
>
>
>
> *From:* Nagaraj S [mailto:nagaraj.chk_at_gmail.com]
> *Sent:* Monday, February 08, 2016 4:10 AM
> *To:* oracle-l
> *Subject:* OEM Database Target Host
>
>
>
> Good Morning All,
>
>
>
> We have middleware ,database and application hosts targets monitored in
> OEM12c and I have a situation to pull the list of database host, I tried by
> issuing emcli get_targets -noheader -script -targets=host, it shows all
> the targets(Middleware, Database and Application). Is there any way I we
> can get only database host using emcli or by querying internal tables?
> Thanks in Advance
>
>
>
> -Naga
>

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