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:

  Copy Code
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:

  Copy Code
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:

  Copy Code
select InvClassName from v_GroupMap where ResourceType = 5

Send comments about this topic to Microsoft.