Hardware Inventory View Reference
The hardware inventory views contain information about the computer hardware scanned on Microsoft Systems Management Server (SMS) clients. Many inventory views are created in SMS by default, and many more may be created depending on which classes and properties are enabled in the SMS_DEF.MOF file, whether or not SMS add-ons are installed (such as the Device Management Feature Pack), which SMS components are configured, and so forth. Because of this, it is likely that SMS sites collect different hardware inventory resulting in different hardware inventory views.
Hardware Inventory Schema
The hardware inventory schema is important to understand when creating queries for SMS reports. Most of the client data within SMS is contained in one of the hardware inventory views. The two hardware inventory schema information views are 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.
Because hardware inventory can be configured through enabling or disabling classes in the SMS_DEF.MOF, one SMS site's SQL database may 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
The hardware inventory views all 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 field, which is demonstrated in the Hardware Inventory View Sample Queries section of Appendix B. The hardware inventory views are listed in the following table.
Hardware Inventory View |
|---|
v_GS_ADD_REMOVE_PROGRAMS |
v_GS_CDROM |
v_GS_COMPUTER_SYSTEM |
v_GS_DESKTOP_MONITOR |
v_GS_DISK |
v_GS_IDE_CONTROLLER |
v_GS_KEYBOARD_DEVICE |
v_GS_LOGICAL_DISK |
v_GS_Mapped_Add_Remove_Programs |
v_GS_MODEM_DEVICE |
v_GS_MOTHERBOARD_DEVICE |
v_GS_NETWORK_ADAPTER |
v_GS_NETWORK_ADAPTER_CONFIGUR |
v_GS_NETWORK_CLIENT |
v_GS_OPERATING_SYSTEM |
v_GS_PARALLEL_PORT |
v_GS_PARTITION |
v_GS_PATCHSTATE |
v_GS_PATCHSTATEEX |
v_GS_PatchStatus |
v_GS_PatchStatusEx |
v_GS_PC_BIOS |
v_GS_POINTING_DEVICE |
v_GS_PROCESSOR |
v_GS_SCANPACKAGEVERSION |
v_GS_SCSI_CONTROLLER |
v_GS_SERVICE |
v_GS_SMS_ADVANCED_CLIENT_STAT |
v_GS_SoftwareUsageData |
v_GS_SOUND_DEVICE |
v_GS_SYSTEM |
v_GS_SYSTEM_ENCLOSURE |
v_GS_TAPE_DRIVE |
v_GS_USB_CONTROLLER |
v_GS_VIDEO_CONTROLLER |
v_GS_VULNERABILITY |
v_GS_VULNERABILITYDETAIL |
v_GS_WORKSTATION_STATUS |
v_GS_X86_PC_MEMORY |