Hardware Inventory Views in Configuration Manager
Updated: January 1, 2014
Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 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 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 the following table.
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 To enable or disable existing inventory classes section of the How to Extend Hardware Inventory in Configuration Managertopic in the Configuration Manager Documentation Library
Hardware inventory view |
Description |
|---|---|
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_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_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_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_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_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 in Configuration Manager 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_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_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_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 connected to 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_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_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_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_SYSTEMHEALTHAGENT |
Lists information about the Configuration Manager System Health Agent. 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_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_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_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. |
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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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. |