How to See a Configuration Manager View by Using SQL Server

  • Article

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

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

Examples

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

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