Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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