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:
 Copy Code |
|
|---|---|
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:
| Copy Code |
|
|---|---|
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:
| Copy Code |
|
|---|---|
select InvClassName from v_GroupMap where ResourceType = 5 |
|