Share via

How to See a Configuration Manager View by Using SQL Server

  • Article

 

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

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

Examples

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

  • In SQL Server 2008, 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 2008, 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 2008, query the Configuration Manager database with the following SQL statement:
select InvClassName from v_GroupMap where ResourceType = 5

See Also

Configuration Manager Schema
Configuration Manager Programming Fundamentals