Configuration Manager Schema SQL Views
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
In Configuration Manager 2007, a number of schema information views are created to get information about the names of all the available views and the schema for the inventory and discovery classes. These are particularly useful for determining the names for custom inventory resource type (architecture) tables. The following table shows a list of these schema information views.
| View | Description |
|---|---|
v_SchemaViews |
Lists all the views in the view schema family. |
v_ResourceMap |
Lists the resource type views. |
v_ResourceAttributeMap |
Lists attributes for each resource type. |
v_GroupMap |
Lists inventory groups for each inventory architecture. |
v_GroupAttributeMap |
Lists attributes for each inventory group. |
v_ReportViewSchema |
Parallel to the SMS_ReportViewSchema class, this view lists all the classes and properties. |
For more information about how the SQL views map to their WMI class equivalents, see Configuration Manager Schema View Mapping
See Also
Concepts
About Configuration Manager Schema
Configuration Manager Schema Overview
Configuration Manager Schema View Mapping
Configuration Manager SQL View Security