Configuration Manager Schema SQL Views
In Configuration Manager, 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 | Sample Query |
|---|---|---|
| v_SchemaViews | Lists all the views in the view schema family. | Select ViewName, Type from v_SchemaViews order by ViewName |
| v_ResourceMap | Lists the resource type views. | select * from v_ResourceMap |
| v_ResourceAttributeMap | Lists attributes for each resource type. | select * from v_ResourceAttributeMap |
| v_GroupMap | Lists inventory groups for each inventory architecture. | select * from v_GroupMap |
| v_GroupAttributeMap | Lists attributes for each inventory group. | select * from v_GroupAttributeMap |
| v_ReportViewSchema | Parallel to the SMS_ReportViewSchema class, this view lists all the classes and properties. |
select * from v_ReportViewSchema |
For more information about how the SQL views map to their WMI class equivalents, see Configuration Manager Schema View Mapping
See Also
Configuration Manager Schema Overview
Configuration Manager Schema View Mapping
Configuration Manager SQL View Security