Understand SCCM SQL Server Views

Owned by Genhan Chen
Last updated: May 17, 2023

Reference: https://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/discovery-views-configuration-manager

The Configuration Manager discovery views consist of system resource objects, which include any resources that were discovered on the network.

Retrieve resource map info for the discovery view using the following query:

select rm.DisplayName, rm.ResourceClassName, ram.PropertyDisplayName, ram.ColumnName from v_ResourceMap rm full join v_ResourceAttributeMap ram on rm.ResourceType = ram.ResourceType

A sample resource map data is attached.