2 Replies Latest reply: Mar 8, 2013 8:42 AM by EricvdS RSS

    How to find server model from 11g OEM mgmt$ views

    789987
      How to find server model from 11g OEM mgmt$ views

      server model like Dell 710, DL380 G7 etc..,
        • 1. Re: How to find server model from 11g OEM mgmt$ views
          Davewolf-Oracle
          Repository Views are documented in the extensibility guide:
          http://docs.oracle.com/cd/E11857_01/em.111/e12135/views.htm#BACCEIBI

          You should be able to find it under the host information.

          Regards,
          Dave
          • 2. Re: How to find server model from 11g OEM mgmt$ views
            EricvdS
            It is included in this query (run as user SYSMAN):
            SELECT t.target_name AS host_name,
            ecm_util.HOST_HOME_LIST (t.target_name, t.target_type) AS home_info,
            hw.vendor_name AS Vendor,
            hw.system_config AS System_Config,
            hw.machine_architecture Architecture,
            os.name AS os_name,
            os.base_version os_base_version,
            os.update_level os_update_level,
            os.address_length_in_bits os_address_length_in_bits
            FROM mgmt_targets t, mgmt_ecm_snapshot s, mgmt_hc_os_summary os, MGMT_HC_HARDWARE_MASTER hw
            WHERE t.target_type = 'host'
            AND t.target_name = s.target_name
            AND s.snapshot_type = 'host_configuration'
            AND s.target_type = 'host'
            AND s.is_current = 'Y'
            AND s.snapshot_guid = os.snapshot_guid
            AND hw.snapshot_guid = s.snapshot_guid
            ORDER by t.target_type

            The asked info is available in the view MGMT_HC_HARDWARE_MASTER, column: SYSTEM_CONFIG

            Eric