This discussion is archived
3 Replies Latest reply: Feb 15, 2013 8:18 AM by User477708-OC RSS

Report to excel of hosts

User477708-OC Journeyer
Currently Being Moderated
Possible to export info of all hosts monitored to excel from OEM?

11g.

want to get host, IP, OS, ram, cpu, blah, blah....
  • 1. Re: Report to excel of hosts
    User477708-OC Journeyer
    Currently Being Moderated
    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?
  • 2. Re: Report to excel of hosts
    Courtney Llamas Journeyer
    Currently Being Moderated
    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.
  • 3. Re: Report to excel of hosts
    User477708-OC Journeyer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points