This content has been marked as final. Show 3 replies
if not possible to export directly from OEM (cant find anythign which says i can from 11), what tables in OEM hold this info, I can create an ODBC select from excel directly in to the EOM database?
Yes, you can query the Management Repository Views - described in the Extensibility Guide http://docs.oracle.com/cd/E11857_01/em.111/e12135/views.htm#BACCEIBI
MGMT$OS_HW_SUMMARY might have most of what you're looking for.
yep, got most of what Im looking for...thanks
SELECT distinct a.host_name AS "SERVER NAME", a.os_summary, a.cpu_count AS "# Active CPUs", a.mem || ' kb' AS "Mem KB", b.inet_address AS "Server IP Address", b.host_aliases, c.target_name AS "Instance Name" FROM mgmt$os_hw_summary a, mgmt$hw_nic b, mgmt$target_components c WHERE a.host_name=c.host_name AND b.host_name=c.host_name AND b.inet_address IS NOT NULL AND b.inet_address <> '127.0.0.1' and c.target_type = 'oracle_database' ORDER BY 1,5