The hardware inventory views contain information about the computer hardware scanned on Configuration Manager 2007 client computers. Many hardware inventory views are created in Configuration Manager by default, and many more can be created depending on which classes and properties are enabled in the SMS_DEF.MOF file, what version of Configuration Manager is installed, which Configuration Manager components are configured, and so forth. Because of this, it is likely that Configuration Manager sites collect different hardware inventory resulting in different hardware inventory views.

Hardware Inventory Schema Views

The hardware inventory schema is important to understand when creating queries for Configuration Manager reports. Most of the client data within Configuration Manager is contained in one of the two hardware inventory schema views: v_GroupMap and v_GroupAttributeMap. The v_GroupMap view contains a list of all the hardware inventory groups and the associated view for each of the groups. The v_GroupAttributeMap contains all of the attributes that are inventoried for each of the groups. Both views can be joined together by using the GroupID column and joined to the v_ResourceMap discovery schema view by using the ResourceType column.

Because hardware inventory can be configured through enabling or disabling classes in the SMS_DEF.MOF, one Configuration Manager site's SQL database might have different hardware inventory views and schema when compared to another site. The following query joins the v_GroupMap and v_GroupAttributeMap to generate the hardware inventory view schema, based on the specific SMS_DEF.MOF file settings for the site:

SELECT DISTINCT GM.DisplayName, GM.InvClassName,

  GM.InvHistoryClassName, GAM.AttributeName,

  GAM.ColumnName, GM.MIFClass

FROM v_GroupMap GM INNER JOIN v_GroupAttributeMap GAM

  ON GM.GroupID = GAM.GroupID

Hardware Inventory Views

Most of the hardware inventory views start with the v_GS_ view name followed by the name of the hardware component, such as CDROM (for example, v_GS_CDROM). As a general rule, each hardware inventory view has an associated inventory history view that starts with the v_HS_ view name. The hardware inventory views can all be joined with other system data views by using the ResourceID column, which is demonstrated in Appendix A, in the topic Hardware Inventory View Sample Queries. The standard hardware inventory views are described in the following table.

Hardware Inventory View Description

v_Add_Remove_Programs

Lists information about the software installed on Configuration Manager clients that is registered in Add or Remove Programs.

The view can be joined with other views by using the ResourceID column.

v_GS_ACTIVESYNC_CONNECTED_DEV

Lists information about devices connected to Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_ACTIVESYNC_SERVICE

Lists information about the Active Sync service on Configuration Manager clients, including the version and last synchronization time.

The view can be joined with other views by using the ResourceID column.

v_GS_ADD_REMOVE_PROGRAMS

Lists information about the software installed on Configuration Manager clients that is registered in Add or Remove Programs.

The view can be joined with other views by using the ResourceID column.

v_GS_ADD_REMOVE_PROGRAMS_64

Lists information about the 64-bit software installed on Configuration Manager client computers that is registered in Add or Remove Programs.

The view can be joined with other views by using the ResourceID column.

v_GS_ADVANCED_CLIENT_SSL_CONF

Lists all Configuration Manager clients, by ResourceID, and associated Secure Sockets Layer (SSL) information for the resource, if applicable.

The view can be joined with other views by using the ResourceID column.

v_GS_AUTOSTART_SOFTWARE

Lists information about the applications on Configuration Manager clients that start automatically with the operating system found through Asset Intelligence. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_BROWSER_HELPER_OBJECT

Lists information about the browser objects found on Configuration Manager clients through Asset Intelligence. While some browser helper objects are beneficial, most software considered "malware" is in the form of browser helper objects. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_CCM_RECENTLY_USED_APPS

Lists information about the applications found on Configuration Manager clients, through software metering, that were recently run.

The view can be joined with other views by using the ResourceID column.

v_GS_CDROM

Lists information about CDROM devices found on Configuration Manager clients.

This view can be joined with other views by using the ResourceID column.

v_GS_COMPUTER_SYSTEM

Lists information about the Configuration Manager clients, including domain, computer name, Configuration Manager roles, status, system type, and so on.

The view can be joined with other views by using the ResourceID column.

v_GS_DESKTOP_MONITOR

Lists information about the desktop monitors found on Configuration Manager client computers.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_CERTIFICATEINFORM

Lists information about the certificates on devices, including the expire date, subject name, and hash for enrolled and registered certificates. The view is also listed and described in the Mobile Device Management Views topic.

This view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_CERTIFICATES

Lists information about the certificates on devices, including the revision ID, issuer, where it is located in the certificate store, the subject, the dates the certificate is valid, and so on. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_COMPUTER_SYSTEM

Lists information about the Configuration Manager devices, including the device ID, number of processors, platform type, processor type, and so on. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_DISPLAY

Lists information about the displays found on Configuration Manager devices. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_FILESYSTEM

Lists information about the file system found on Configuration Manager devices. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_MEMORY

Lists information about the memory found on Configuration Manager devices. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_NETWORK

Lists information about the network used by Configuration Manager devices, such as bandwidth, IP address, IP subnet, MAC address, and so on. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_OS_INFORMATION

Lists information about the operating system found on Configuration Manager devices. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_OWNERINFORMATION

Lists owner information found on Configuration Manager devices, including e-mail address, name, notes, telephone, and so on. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_PHONEIDENTIFICATI

Lists phone information for Configuration Manager devices that have phone functionality. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_POWER

Lists information about power settings and the battery on Configuration Manager devices. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DEVICE_USERINFORMATION

Lists information about the users on Configuration Manager devices, including user locale and user name. The view is also listed and described in the Mobile Device Management Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_DISK

Lists information about the disk drives found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_IDE_CONTROLLER

Lists information about the IDE controllers found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_INSTALLED_EXECUTABLE

Lists information about the installed software application executables on Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_INSTALLED_SOFTWARE

Lists information about the installed software applications on Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column and with Asset Intelligence views by using the SoftwareCode0 and SoftwarePropertiesHash0 columns.

v_GS_INSTALLED_SOFTWARE_CATEGORIZED

Lists information about the installed software applications on Configuration Manager clients found through Asset Intelligence. This view contains the information in the v_GS_INSTALLED_SOFTWARE view and joins several other tables to provide additional details about the installed software. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column and with Asset Intelligence views by using the SoftwareCode0, SoftwarePropertiesHash0, FamilyID, CategoryID, and SoftwareID columns.

v_GS_INSTALLED_SOFTWARE_MS

Lists information about the installed Microsoft software applications on Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_KEYBOARD_DEVICE

Lists information about keyboards found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_LOGICAL_DISK

Lists information about the logical disks found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_MODEM_DEVICE

Lists information about modems found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_MOTHERBOARD_DEVICE

Lists information about the motherboard found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_NAPCLIENT

Lists information about the Configuration Manager clients with the Network Access Protection (NAP) client installed, including whether the client is NAP enabled, the NAP protocol version, system isolation state, and so on. The view is also listed and described in the Network Access Protection Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_NETWORK_ADAPTER

Lists information about the network adapters found on Configuration Manager clients, including adapter type, description, MAC address, manufacturer, service name, and so on.

This view can be joined with other views by using the ResourceID column.

v_GS_NETWORK_ADAPTER_CONFIGUR

Lists information about the configuration for network adapters found on Configuration Manager clients, including default IP gateway, whether DHCP is enabled, the DHCP server, DNS domain, IP address, IP subnet, and so on.

The view can be joined with other views by using the ResourceID column.

v_GS_NETWORK_CLIENT

Lists information about the network clients found on Configuration Manager clients, including description, manufacturer, name, status, and so on.

The view can be joined with other views by using the ResourceID column.

v_GS_OPERATING_SYSTEM

Lists information about the operating system found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_PARALLEL_PORT

Lists information about parallel ports found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_PARTITION

Lists information about disk partitions found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_PATCHSTATE

Lists all software updates that are, or have been, applicable to each client. The view contains the resource ID, update source path, update ID, associated article number, date posted, what product the patch updates, scan agent used, status, time applied, and so forth. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the ResourceID, GroupID, and ID0 columns.

Note
This view contains information from clients that were scanned for software updates compliance by using an inventory scan tool, such as the Inventory Tool for Microsoft Updates, and where the information is retrieved as part of hardware inventory.

v_GS_PATCHSTATEEX

Lists all software updates that are, or have been, applicable to each client. The view contains the resource ID, update source path, update ID, associated article number, date posted, what product the patch updates, scan agent used, status, time applied, product ID, revision number, and so forth. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the ResourceID, GroupID, ID0, and UpdateID0 columns.

Note
This view contains information from clients that were scanned for software updates compliance by using an inventory scan tool, such as the Inventory Tool for Microsoft Updates, and where the information is retrieved as part of hardware inventory.

v_GS_PatchStatus

Lists all software updates that are, or have been, applicable to each client. The view contains the resource ID, update ID, update title, associated article number, what product the update is associated with, update language, last status for installation, and so forth. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the ResourceID, ID, or QNumbers columns.

Note
This view contains information from clients that were scanned for software updates compliance by using an inventory scan tool, such as the Inventory Tool for Microsoft Updates, and where the information is retrieved as part of hardware inventory.

v_GS_PatchStatusEx

Lists all software updates that are, or have been, applicable to each client. The view contains the resource ID, update ID, update title, associated article number, what product the update is associated with, update language, last status for installation, and so forth. This view contains information from clients that were scanned for software updates compliance by using an inventory scan tool, such as the Inventory Tool for Microsoft Updates, and where the information is retrieved as part of hardware inventory. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the ResourceID, ID, QNumbers, ProductID, or UniqueUpdateID columns.

v_GS_PC_BIOS

Lists information about the BIOS found on Configuration Manager clients.

This view can be joined with other views by using the ResourceID column.

v_GS_PNP_DEVICE_DRIVER

Lists information about the device drivers found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_POINTING_DEVICE

Lists information about the pointing devices found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_PROCESSOR

Lists information about the processors found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column and to the v_LU_CPU Asset Intelligence view by using the CPUHash0 column.

v_GS_SCANPACKAGEVERSION

Lists the software update scan tools installed on resources by scan type, resource ID, group ID, revision ID, package ID, package version, time of last update, and so forth. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the ResourceID or PackageID0 columns.

Note
This view contains information from clients that were scanned for software updates compliance by using an inventory scan tool, such as the Inventory Tool for Microsoft Updates, and where the software updates information is retrieved as part of hardware inventory.

v_GS_SCSI_CONTROLLER

Lists information about the SCSI controllers found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_SERVICE

Lists information about the services found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_SMS_ADVANCED_CLIENT_STAT

Lists information about the Configuration Manager client components found on clients.

The view can be joined with other views by using the ResourceID column.

v_GS_SOFTWARE_LICENSING_PRODU

Lists software licensing product information for Windows Vista Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_SOFTWARE_LICENSING_SERVI

Lists software licensing service information for Windows Vista Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_SOFTWARE_SHORTCUT

Lists software shortcut information for Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_SOUND_DEVICE

Lists information about the sound devices found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_SYSTEM

Lists information about the active Configuration Manager clients, including domain, name, system role, system type, and so on.

The view can be joined with other views by using the ResourceID column.

v_GS_SYSTEM_CONSOLE_USAGE

Lists all system console usage information for Configuration Manager clients found through Asset Intelligence by polling the System Security Event Log. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP

Lists all system console usage information for Configuration Manager clients found through Asset Intelligence by polling the System Security Event Log. This view contains a subset of information from the v_GS_SYSTEM_CONSOLE_USAGE view. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_SYSTEM_CONSOLE_USER

Lists all system console user information for Configuration Manager clients found through Asset Intelligence by polling the System Security Event Log. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_SYSTEM_DEVICES

Lists information about the system devices found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_SYSTEM_ENCLOSURE

Lists information about the system enclosure found on Configuration Manager clients, including chassis types, serial number, SMBIOS asset tag, and so on.

The view can be joined with other views by using the ResourceID column.

v_GS_SYSTEM_ENCLOSURE_UNIQUE

Lists information about the unique system enclosures found on Configuration Manager clients, including serial number, SMBIOS asset tag, and so on. This view contains a subset of information from the v_GS_SYSTEM_ENCLOSURE view.

The view can be joined with other views by using the ResourceID column.

v_GS_TAPE_DRIVE

Lists information about the tape drives found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_USB_CONTROLLER

Lists information about the USB controllers found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_USB_DEVICE

Lists information about the USB devices found on Configuration Manager clients through Asset Intelligence. The view is also listed and described in the Asset Intelligence Views topic.

The view can be joined with other views by using the ResourceID column.

v_GS_VIDEO_CONTROLLER

Lists information about the video controllers found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_VIRTUAL_APPLICATION_PACK

Lists virtual application package information found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

Note
This view was introduced in Configuration Manager 2007 SP1.

v_GS_VIRTUAL_APPLICATION_PACKAGES

Lists virtual application package information found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

Note
This view was introduced in Configuration Manager 2007 SP1.

v_GS_VIRTUAL_APPLICATIONS

Lists information about virtual applications found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

Note
This view was introduced in Configuration Manager 2007 SP1.

v_GS_VIRTUAL_MACHINE

Lists information about the virtual machines found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_VULNERABILITY

Lists vulnerability information found on Configuration Manager clients by using a vulnerability scan tool. This view is data received from Systems Management Server (SMS) 2003 clients and is not used by Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_VULNERABILITYDETAIL

Lists detailed vulnerability information found on Configuration Manager clients by using a vulnerability scan tool. This view is data received from SMS 2003 clients and not used by Configuration Manager clients.

This view can be joined with other views by using the ResourceID column.

v_GS_WINDOWSUPDATEAGENTVERSIO

Lists information about the Windows Update Agent found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_GS_WORKSTATION_STATUS

Lists workstation status information for Configuration Manager clients, including last hardware scan, default locale ID, time zone offset, and so on.

The view can be joined with other views by using the ResourceID column.

v_GS_X86_PC_MEMORY

Lists information about the memory found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

v_Network_DATA_Serialized

Lists information about the network item found on Configuration Manager clients, and organized by ResourceID and then by GroupID. The GroupID column starts at 1 for the first network item for a client and increments by 1 for each additional network item. The view lists the IP address for the default gateway, the IP address for the DHCP server, DNS domain, IP address, MAC address, and so on.

The view can be joined with other views by using the ResourceID column.

v_SystemInventoryChanges

Lists information about the inventory changes on Configuration Manager clients, including name, MIF class, time stamp, change type, and so on.

The view can be joined with other views by using the ResourceID column.

See Also