how-to-see-a-configuration-manager-view-by-using-sql-server.md

description	title	titleSuffix	ms.date	ms.subservice	ms.service	ms.topic	ms.assetid	author	ms.author	manager	ms.localizationpriority	ms.collection	ms.reviewer
The following examples demonstrate various Microsoft Configuration Manager SQL view queries.	See a View by Using SQL Server	Configuration Manager	09/20/2016	sdk	configuration-manager	how-to	8a8df275-7e63-4159-9f9a-5f21621be0f1	Banreet	banreetkaur	apoorvseth	low	tier3	mstewart,aaroncz

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