Hardware inventory views in Configuration Manager
The hardware inventory views contain information about the computer hardware scanned on Configuration Manager client computers. Many hardware inventory views are created in Configuration Manager by default, and many more can be enabled or creating classes by using the hardware inventory classes dialog box, accessible from client settings. Because of this, it is likely that Configuration Manager sites collect different hardware inventory resulting in different hardware inventory views.
For more information about extending Configuration Manager hardware inventory, see How to extend hardware inventory in Configuration Manager.
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 view 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 extended, one Configuration Manager site's SQL Server 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 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 Sample queries for hardware inventory in Configuration Manager. The standard hardware inventory views are described in this section.
Note
Not all of the items listed are collected by default when using Configuration Manager hardware inventory. For information about how to enable or disable hardware inventory classes, see the How to extend hardware inventory in Configuration Manager topic in the Configuration Manager Documentation Library
v_InventoryClass
Lists the WMI classes that are collected by Configuration Manager hardware inventory by class ID. The view also shows the WMI namespace, the class name and the name of the class as it will be displayed in Resource Explorer. This view can be joined to other views by using the ClassID column.
v_InventoryClassProperty
Lists the properties collected from each inventory class by Configuration Manager hardware inventory. This view is unlikely to be joined to other views.
v_InventoryReport
Lists information about the last inventory taken by Configuration Manager. This can include hardware inventory, software inventory, and discovery. This view is unlikely to be joined to other views.
v_InventoryReportClass
Lists the inventory classes and properties used by Configuration Manager hardware inventory. This view is unlikely to be joined to other views.
v_CustomInventoryReport
Lists details about hardware inventory collected from clients that have custom hardware inventory client settings deployed. This view can be joined to other views by using the CollectionID column.
v_Add_Remove_Programs
Lists information about the software installed on Configuration Manager clients that is registered in Add or Remove Programs or Programs and Features list. The view can be joined with other views by using the ResourceID column.
v_GS_1394_CONTROLLER
Lists details about 1394 controllers on clients. This includes the manufacturer, the install date and more. This view can be joined to other views by using the ResourceID column.
v_GS_ACTIVESYNC_CONNECTED_DEVICE
Lists information about devices connected to Configuration Manager clients by using Exchange ActiveSync. The view can be joined with other views by using the ResourceID column.
v_GS_ACTIVESYNC_SERVICE
Lists information about the Exchange ActiveSync 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 shown in the list of installed programs in Windows Control Panel. 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 shown in the list of installed programs in Windows Control Panel. The view can be joined with other views by using the ResourceID column.
v_GS_ADVANCED_CLIENT_SSL_CONFIGURATIONS
Lists all Configuration Manager clients, by resource ID, 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_APPV_CLIENT_APPLICATION
Lists computers that have the App-V client application installed. The view can be joined with other views by using the ResourceID column.
V_GS_APPV_CLIENT_PACKAGE
Lists computers that have the App-V client package installed. 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 in Configuration Manager topic. The view can be joined with other views by using the ResourceID column.
v_GS_BASEBOARD
Lists information about the motherboard on Configuration Manager client computers. This includes the serial number of the motherboard, a description and more. This view can be joined to other views by using the ResourceID column.
v_GS_BATTERY
Returns details about any computer that contains a battery, such as a notebook computer. Includes information about the type of battery, any errors it has reported, when it was installed, and more. The view can be joined with other views by using the ResourceID column.
v_GS_BOOT_CONFIGURATION
Lists information about the folders and resources Windows uses to start on client computers, such as the startup folder, the location of Windows, the boot partition and more. This view can be joined to 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, malware might be delivered is in the form of browser helper objects. The view is also listed and described in the Asset intelligence views in Configuration Manager 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 more. The view can be joined with other views by using the ResourceID column.
v_GS_COMPUTER_SYSTEM_PRODUCT
Lists general information about inventoried client devices including the manufacturer and model. This view can be joined to other views by using the ResourceID column.
v_GS_DESKTOP
Lists information about the desktop settings on client computers including the icon size, wallpaper settings, fonts and more. 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_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 in Configuration Manager topic. The view can be joined with other views by using the ResourceID column.
v_GS_DEVICE_COMPUTERSYSTEM
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 in Configuration Manager 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 in Configuration Manager 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 in Configuration Manager topic. The view can be joined with other views by using the ResourceID column.
v_GS_DEVICE_OSINFORMATION
Lists information about the operating system found on Configuration Manager devices. The view is also listed and described in the Mobile device management views in Configuration Manager 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 in Configuration Manager 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_DMA_CHANNEL
Lists information about the Direct Memory Access (DMA) channels found on client computers. This view can be joined to other views by using the ResourceID column.
v_GS_EMBEDDED_DEVICE_INFO
Lists information about Windows Embedded devices, including the model name of the device. The view can be joined with other views by using the ResourceID column.
v_GS_ENCRYPTABLE_VOLUME
Lists the encryptable disk volumes found on Windows computers. The view can be joined with other views by using the ResourceID column.
v_GS_ENVIRONMENT
Lists details about the Windows environment variables found on client computers. The view can be joined with other views by using the ResourceID column.
v_GS_FOLDER_REDIRECTION_HEALTH
Lists information about the status of folder redirection on Windows computers. 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 executable files (files with the extension .exe) on Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset intelligence views in Configuration Manager 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 in Configuration Manager 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 in Configuration Manager 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 in Configuration Manager topic.
The view can be joined with other views by using the ResourceID column.
v_GS_IRQ
List information about Interrupt Requests (IRQ's) found on client computers. This view can be joined to 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_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_CONFIGURATION
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 more. The view can be joined with other views by using the ResourceID column.
V_GS_NETWORK_LOGIN_PROFILE
Lists information about the login profiles found on Configuration Manager clients. The view can be joined with other views by using the ResourceID column.
v_GS_NT_EVENTLOG_FILE
Lists detailed information about the Windows Event Logs found on client computers. This includes file names, paths, maximum and current sizes, and more.
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_OS_RECOVERY_CONFIGURATION
Lists information about the actions that Windows clients take when they experience an unrecoverable error. The view can be joined with other views by using the ResourceID column.
v_GS_PAGE_FILE_SETTING
List information about the paging file on Windows computers. This includes the initial size and the maximum size for the page file. This 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_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_PCMCIA_CONTROLLER
Lists information about the type, capabilities and status of any PCMCIA controllers inventoried on client computers. This view can be joined with other views by using the ResourceID column.
v_GS_PHYSICAL_MEMORY
Lists information about the physical memory installed in devices. Includes the capacity, manufacturer, description and more. The view can be joined with other views by using the ResourceID column.
v_GS_PORT
Lists information about the ports on each client computer. This view can be joined with other views by using the ResourceID column.
v_GS_PORTABLE_BATTERY
Lists information about the battery on portable computers, including its status, type, voltage and expected life. This view can be joined to other views by using the ResourceID column.
v_GS_POWER_SUPPLY
Lists information about the power supply used by the Configuration Manager client device. This includes information about remaining charge, reported errors, power management capabilities and more. This view can be joined to other views by using the ResourceID column.
v_GS_POINTING_DEVICE
Lists information about the pointing devices connected to Configuration Manager clients. The 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_PRINT_JOB
Lists, by resource ID, information about jobs that are in the printer queue of client computers. This view can be joined with other views by using the ResourceID column.
v_GS_PRINTER_CONFIGURATION
Lists information about the configuration of printers attached to a device, including the printer name, whether it has double-sided (duplex) capabilities, its driver version and more. This view can be joined with other views by using the ResourceID column.
v_GS_PRINTER_DEVICE
Lists information about the print devices attached to clients, including the model, print capabilities and current status at the time the inventory was ran. This view can be joined with other views by using the ResourceID column.
v_GS_PROCESS
Lists information about the Windows processes that were running on client computers at the time they ran hardware inventory. This 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_PROTECTED_VOLUME_INFO
Lists information about protected disk volumes found on client computers. The view can be joined with other views by using the ResourceID column.
v_GS_PROTOCOL
Lists detailed information about the network protocols used by client computers. The view can be joined with other views by using the ResourceID column.
v_GS_QUICK_FIX_ENGINEERING
Lists information about Windows hotfixes installed on client computers. Includes the name of the hotfix, who installed it and when, a description of the hotfix, and more. The view can be joined with other views by using the ResourceID column.
v_GS_REGISTRY
Lists information about the registry on client computers such as its current size and its maximum size. This view can be joined to other views by using the ResourceID column.
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_SERVER_FEATURE
Lists the server features that are installed on Windows Server computers. The view can be joined with other views by using the ResourceID column.
v_GS_SERIAL_PORT
Lists information about the type, capabilities and status of serial ports inventoried on client computers. This view can be joined with other views by using the ResourceID column.
v_GS_SERIAL_PORT_CONFIGURATION
Lists information about the serial ports on clients. This view can be joined to other views by using the ResourceID column.
v_GS_SERVICE
Lists information about the Windows services found on Configuration Manager clients. The view can be joined with other views by using the ResourceID column.
v_GS_SHARE
Lists information about shared folders found on client computers. The view can be joined with other views by using the ResourceID column.
v_GS_SMS_ADVANCED_CLIENT_STATE
Lists information about the name and version of Configuration Manager client components found on clients. The view can be joined with other views by using the ResourceID column.
v_GS_SOFTWARE_LICENSING_PRODUCT
Lists software licensing product information for Windows Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset intelligence views in Configuration Manager topic. The view can be joined with other views by using the ResourceID column.
v_GS_SOFTWARE_LICENSING_SERVICE
Lists software licensing service information for Windows Configuration Manager clients found through Asset Intelligence. The view is also listed and described in the Asset intelligence views in Configuration Manager 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 in Configuration Manager 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 more. The view can be joined with other views by using the ResourceID column.
v_GS_SYSTEM_ACCOUNT
Lists information about the system accounts on Windows computers. 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 Windows System Security Event Log. The view is also listed and described in the Asset intelligence views in Configuration Manager 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 Windows 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 in Configuration Manager 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 Windows System Security Event Log. The view is also listed and described in the Asset intelligence views in Configuration Manager 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_DRIVER
Lists information about the drivers 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_SYSTEMBOOTDATA
Lists information about the computer boot times. This includes BIOS duration, boot duration, event log start, group policy duration, system start time and update duration.
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_TIME_ZONE
Lists information about the time zone settings on clients. This view can be joined with other views by using the ResourceID column.
v_GS_TPM
Lists information about the Trusted Platform Model (TPM) chip when it is found on client computers. This view can be joined with other views by using the ResourceID column.
v_GS_TS_ISSUED_LICENSE
Lists information about issued Terminal Services licenses. The view can be joined with other views by using the ResourceID column.
v_GS_TS_LICENSE_KEY_PACK
Lists information about Terminal Services key packs found on client computers. 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 in Configuration Manager topic. The view can be joined with other views by using the ResourceID column.
v_GS_USER_PROFILE
Lists information about user profiles found on client computers including the path to the profile, roaming preferences and more. This view can be joined to 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_PACKAGES
Lists virtual application package information found on Configuration Manager clients. The view can be joined with other views by using the ResourceID column.
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.
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_WEBAPP_APPLICATION
Lists information about Web applications found on clients. This includes the name and URL to the application. The view can be joined with other views by using the ResourceID column.
v_GS_WINDOWS8_APPLICATION
Lists the installed modern Windows applications found on client computers. This view can be joined to other views by using the ResourceID column.
v_GS_WINDOWS8_APPLICATION_USER_INFO
Lists user account information for the modern Windows applications found on client computers. This view can be joined to other views by using the ResourceID column.
v_GS_WINDOWSUPDATEAGENTVERSION
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_WRITE_FILTER_STATE
Lists information about whether the write filter is enabled on Windows Embedded devices. 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 more. The view can be joined with other views by using the ResourceID column.