Partager via


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