3 Replies Latest reply: Feb 15, 2013 10:18 AM by oralicious RSS

    Report to excel of hosts

    oralicious
      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
          oralicious
          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-Oracle
            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
              oralicious
              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