Alone with it I need to get the status of target like its UP, down or Agent
unreachable, I checked in mgmt$target table and there is no status field do
i need to build my query with any other table? Please advise
On Mon, Feb 8, 2016 at 8:19 PM, Courtney Llamas <courtney.llamas@xxxxxxxxxx>
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@xxxxxxxxx]
*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
