How to See a Configuration Manager View by Using SQL Server

The following examples demonstrate various Microsoft Configuration Manager SQL view queries.

Examples

To determine the display name of a resource type from the resource type number

• In SQL Server, query the Configuration Manager database with the following SQL statement:

select DisplayName from v_ResourceMap where ResourceType=5  

To determine discovery properties for a particular resource type

• In SQL Server, query the Configuration Manager database with the following SQL statement:

select * from v_ResourceAttributeMap where ResourceType=5  

To list the inventory groups for a particular resource type

• In SQL Server, query the Configuration Manager database with the following SQL statement:

select InvClassName from v_GroupMap where ResourceType = 5