Export (0) Print
Expand All

Desired Configuration Management 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

The Configuration Manager 2007 desired configuration management views contain information about the compliance of computers with regard to a number of configurations, such as whether the correct Windows operating system versions are installed and configured appropriately, whether all required applications are installed and configured correctly, whether optional applications are configured appropriately, and whether prohibited applications are installed. The desired configuration management views contain information about the configuration items in the site, which configuration items store information about configuration baselines, software updates, bundles, drivers, and so on. Several of the status and status summarizer views contain status information for the configuration items and configuration item assignments.

The following sections provide detailed information about desired configuration management views, desired configuration management status views, and desired configuration management status summarizer views.

Desired Configuration Management Views

There are many desired configuration management views, and it can sometimes be difficult to find the information that you need for your report SQL statement. There are several key desired configuration management views and view columns. Most often, the CI_ID column will be used to join desired configuration management views, and the v_ConfigurationItems view will be used to retrieve information about the configuration items in the site. The v_CategoryInfo and v_LocalizedCIProperties views will often be used to retrieve additional information about the configuration items. The AssignmentID column and the v_CIAssignment views will be used to retrieve information about the configuration item assignments. The v_CIAssignmentToCI view can be used as the link between the v_ConfigurationItems and v_CIAssignment views. The v_CIAssignmentTargetedMachines view can be used as the link between the v_CIAssignment view and views that contain resource information, such as the v_R_System view. The desired configuration management views are described in the following table.

 

Desired Configuration Management View Description

v_BaselineTargetedComputers

Lists the Configuration Manager clients, by ResourceID, that have been targeted for a configuration baseline, by CI_ID. This view filters the retrieved configuration items by the configuration baseline configuration type (CI_Type = 2).

The view can be joined to other views by using the CI_ID and ResourceID columns.

v_BundledConfigurationItems

Lists configuration item bundles, by CI_ID, and the configuration items that are part of the bundle, by BundledCI_ID. The configuration items in this view have a configuration item relation type of Bundled (RelationType=1).

The view can be joined to other views by using the CI_ID and BundledCI_ID (CI_ID for the bundled configuration item) columns.

noteNote
The configuration item relation types are listed in the v_CIRelationTypes view.

v_BundledConfigurationItems_All

Lists configuration items, by CI_ID, the configuration items that are in the bundle, by BundledCI_ID, and the bundled level for the configuration items. For example, suppose the configuration item ID for an update bundle is listed in the CI_ID column. The configuration item ID for the bundle is listed one time in the BundledCI_ID column with a bundled level of 0. The configuration item ID for the same bundle is listed in the CI_ID column of the next row, with the configuration item ID for a software update that is part of the bundle in the BundledCI_ID column, and it has the bundled level of 1. When the software update is part of another bundle, the bundled level will be 2, and so on. The configuration item IDs for configuration baselines are listed with a bundled level of 0. The configuration items in this view have a configuration item relation type of Bundled (RelationType=1).

The view can be joined to other views by using the CI_ID and BundledCI_ID (CI_ID for the bundled configuration item) columns.

v_Categories

Lists the configuration item category instances, by CategoryInstanceID and CategoryInstance_UniqueID, category type name, date the category instance was last modified, source site, and parent category. This view contains the same source data as the v_CategoryInstances view, but it displays more columns.

The view can be joined to other views by using the CategoryInstanceID and ParentCategoryInstanceID columns.

v_CategoryInfo

Lists the configuration item category instances, by CategoryInstanceID and CategoryInstance_UniqueID, category type name, date the category instance was last modified, source site, parent category, category instance name, and locale ID. This view contains the same data as the v_Categories view plus two additional columns from the v_LocalizedCategories_SiteLoc view.

The view can be joined to other views by using the CategoryInstanceID and ParentCategoryInstanceID columns.

v_CategoryInstances

Lists the configuration item category instances, by category instance ID and category instance unique ID, category type name, date the category instance was last modified, source site, and parent category. This view contains the same source data as the v_Categories view, but it displays fewer columns.

The view can be joined to other views by using the CategoryInstanceID and ParentCategoryInstanceID columns.

v_CI_ApplicablePlatforms

Lists the configuration items, by CI_ID and CI_UniqueID, that have specific applicable platforms configured, including the operating system name, operating system maximum and minimum versions, and operating system platform. For example, a configuration item created in the Configuration Manager console that has All Windows platforms selected for the Applicability property will not be listed in this view, but the view will contain a record for each Windows platform for the configuration item when the Specified Windows platforms is selected.

The view can be joined to other views by using the CI_ID and CI_UniqueID columns.

v_CI_DriverHardwareIDs

Lists the configuration items, by CI_ID and CI_UniqueID, that have a configuration item type of Driver (CIType_ID=6) and the associated hardware IDs that the driver supports. For example, a driver added in the Drivers node under the Operating System Deployment node in the Configuration Manager console will be listed in this view as well as the hardware IDs that it supports.

The view can be joined to other views by using the CI_ID and CI_UniqueID columns.

v_CI_DriverModels

Lists the configuration items, by CI_ID and CI_UniqueID, that have a configuration item type of Driver (CIType_ID=6) and the supported model names and driver manufacturer. The supported models are listed in the Applicability section of the driver properties in the Configuration Manager console.

The view can be joined to other views by using the CI_ID and CI_UniqueID columns.

v_CI_DriversCIs

Lists the configuration items, by CI_ID and CI_UniqueID, that have a configuration item type of Driver (CIType_ID=6), as well as the driver type, driver INF file, driver date, driver version, driver class, driver provider, whether the driver is signed (and if so, the driver signer), and whether the driver is boot critical.

The view can be joined to other views by using the CI_ID and CI_UniqueID columns.

v_CIAssignment

Lists the assignments—by AssignmentID, Assignment_UniqueID, and AssignmentName—that are active in the Configuration Manager hierarchy, including the assignment description, collection ID and name that is targeted by the assignment, start time, enforcement deadline, whether the assignment is an update deployment, and other details about the assignment.

The view can be joined to other desired configuration items, software updates, and status views by using the AssignmentID and Assignment_UniqueID columns, and it can be joined to collection views by using the LocalCollectionID and CollectionID columns.

v_CIAssignmentTargetedCollections

Lists the assignments, by AssignmentID, that are active in the Configuration Manager hierarchy and the associated target collection, by LocalCollectionID, CollectionID, and CollectionName.

The view can be joined to other desired configuration items, software updates, and status views by using the AssignmentID column, and it can be joined to collection views by using the LocalCollectionID and CollectionID columns.

v_CIAssignmentTargetedMachines

Lists the assignments, by AssignmentID, that are active in the Configuration Manager hierarchy and the Configuration Manager clients, by ResourceID, that have been targeted for the assignment.

The view can be joined to other views by using the AssignmentID and ResourceID columns.

v_CIAssignmentToCI

Lists the assignments, by AssignmentID, and the configuration items, by CI_ID, that are in the assignment. For example, if the assignment is a software update deployment, the configuration item ID for each software update in the deployment will be listed.

The view can be joined to other views by using the AssignmentID and CI_ID columns.

v_CICategories

Lists the configuration items, by CI_ID, and the configuration item category instances, by CategoryInstanceID and CategoryInstance_UniqueID, in which they belong, as well as the category type name, date last modified, source site, and parent category instance ID. This view contains the same information as the v_CICategories_All view, except that it does not contain parent categories.

The view can be joined to other views by using the CI_ID, CategoryInstanceID, and ParentCategoryInstanceID columns.

v_CICategories_All

Lists the configuration items, by CI_ID, and the configuration item category instances, by CategoryInstanceID and CategoryInstance_UniqueID, in which they belong, as well as the category type name, date last modified, source site, and parent category instance ID. This view contains the same information as the v_CICategories view, except that it also contains parent categories.

The view can be joined to other views by using the CI_ID, CategoryInstanceID, and ParentCategoryInstanceID columns.

v_CICategoryInfo

Lists the configuration items, by CI_ID, and the configuration item category instances, by CategoryInstanceID and CategoryInstance_UniqueID, in which they belong, as well as the category type name, date the category instance was last modified, source site, parent category, category instance name, and locale ID. This view contains the same data as the v_CICategories view plus two additional columns from the v_LocalizedCategories_SiteLoc view, and the same data as the v_CICategoryInfo_All view, except that it does not contain parent categories.

The view can be joined to other views by using the CI_ID, CategoryInstanceID, and ParentCategoryInstanceID columns.

v_CICategoryInfo_All

Lists the configuration items, by CI_ID, and the configuration item category instances, by CategoryInstanceID and CategoryInstance_UniqueID, in which they belong, as well as the category type name, date the category instance was last modified, source site, parent category, category instance name, and locale ID. This view contains the same data as the v_CICategories_All view plus two additional columns from the v_LocalizedCategories_SiteLoc view, and the same data as the v_CICategoryInfo view, except that it also contains parent categories.

The view can be joined to other views by using the CI_ID, CategoryInstanceID, and ParentCategoryInstanceID columns.

v_CIContents

Lists the configuration items, by CI_ID, that have associated content, which is listed by ContentID, and whether the content has been provisioned. For example, configuration items with the Software Updates (CIType_ID = 1) have associated update files, and Driver configuration types (CIType_ID = 6) have associated driver files.

The view can be joined to other views by using the CI_ID and Content_ID columns.

v_CIContents_All

Lists configuration items that have associated content, by CI_ID, the configuration item ID for the configuration item in which the content is associated, the content ID, whether the content has been provisioned, and so on. The configuration item ID for a configuration item bundle is listed multiple times in the CI_ID column, and the configuration item IDs for the configuration items that are part of the bundle are listed in the ContentCI_ID column. For example, a configuration item that is not a bundle would have the same configuration item ID in the CI_ID and ContentCI_ID columns. A bundle configuration item would have one listing with the configuration item ID in the CI_ID column and the same configuration item ID in the ContentCI_ID columns, and then new listings would contain the configuration item ID for the bundle configuration item in the CI_ID column and the configuration item ID for the bundled configuration items in the ContentCI_ID column. The ContentLevel column represents how many times a configuration item ID is listed in the ContentCI_ID column.

The view can be joined to other views by using the CI_ID, ContentCI_ID, and Content_ID columns.

v_CICurrentSettingsComplianceStatusDetail

Lists the configuration items, by CI_ID, that are in a configuration baseline, that have been assigned to Configuration Manager clients, and are reporting a validation error or noncompliance. The information includes the NetBIOS name of the client, configuration item name, setting name, setting type, setting description, constraint name, constraint description, and validation rule.

The view can be joined to other views by using the CI_ID and ResourceID columns.

v_CIEULA_LocalizedContent

Lists the configuration items, by CI_ID, that have associated license terms, as well as the locale ID, the content unique ID for the license terms, the license terms text, and the source site.

The view can be joined to other views by using the CI_ID column.

v_CIRelation

Lists configuration items, by configuration item ID in the FromCIID column, the configuration items that are related to the first configuration item, by configuration item ID in the TOCIID column, and the type of relation. Configuration items with a bundle level of 1 are listed in the ToCIID column. For example, if the configuration item ID for an update bundle is listed in the FromCIID column and another update bundle is part of the first bundle, only the configuration item ID for the update bundle will be listed in the ToCIID column and not the software updates that are part of the second update bundle.

The view can be joined to other views by using the FromCIID, ToCIID, and RelationType columns. The FromCIID column in this view contains the same information as the CI_ID column, and the ToCIID column contains the same information as the ReferencedCI_ID column in the v_CIRelation_All view.

noteNote
The configuration item relation types can be retrieved from the v_CIRelationTypes view.

v_CIRelation_All

Lists the relationships between configuration items, by CI_ID, and other configuration items, by ReferencedCI_ID, as well as how deep the relationship is between the configuration items, by Level. The CI_ID column lists the configuration item to which the configuration item in the ReferencedCI_ID is related, such as a software updates bundle and associated software updates that are part of the bundle or a configuration baseline and the associated configuration items that are part of the baseline. Configuration items are also listed with a relationship to themselves, which is indicated by a Level value of 0.

For example, let’s say the configuration item ID for an update bundle is listed in the CI_ID column, the same configuration item ID is listed in the ReferencedCI_ID column, and the Level is 0. In a different row, a configuration item ID for a different update bundle is listed in the CI_ID column, the configuration item ID for the same software update that was part of the previous update bundle is listed in the ReferencedCI_ID column because it is also part of this update bundle, and the Level is 1. In a different row, a configuration item ID for an update list is listed in the CI_ID column, the configuration item ID for the same software update that was part of the previous update bundle is listed in the ReferencedCI_ID column because it is also part of this update list, and the Level is 3.

The view can be joined to other views by using the CI_ID and ReferencedCI_ID columns. The CI_ID column in this view is the same as the FromCIID column, and the ReferencedCI_ID column is the same as the ToCIID column in the v_CIRelation and v_CIRelationEx views.

noteNote
The configuration item relation types can be retrieved from the v_CIRelationTypes view.

v_CIRelationEx

Lists the relationships between configuration items, by FromCIID, TOCIID, RelationType, and RelationDepth. The FromCIID column is the configuration item to which the configuration item in the ToCIID is related, such as a software updates bundle and associated software updates that are part of the bundle or a configuration baseline and the associated configuration items that are part of the baseline. The RelationType column indicates the type of relationship between the configuration items, and the RelationDepth column indicates how deep the relationship is for a configuration item listed in the ToCIID column. This view does not display configuration items with a RelationDepth of 0, which is the relationship of the configuration item to itself.

For example, let’s say the configuration item ID for an update bundle is listed in the FromCIID column and the configuration item ID for a software update that is part of the bundle is listed in the ToCIID column. The RelationType in this case is 1 (Bundled), and the RelationDepth is 1. In the next row, a configuration item ID for an update bundle that also contains the previous update is listed in the FromCIID column, the same configuration item ID for the update is listed in the FromCIID column, the RelationType is still 1, and the RelationDepth is now 2. In the next row, a configuration item ID for an update list that contains the same update is listed in the FromCIID column, the same configuration ID for the update is listed in the FromCIID column, the RelationType is still 1, and the RelationDepth is now 3.

The view can be joined to other views by using the FromCIID, ToCIID, and RelationType columns. The FromCIID column in this view contains the same information as the CI_ID column, and the ToCIID column contains the same information as the ReferencedCI_ID column in the v_CIRelation_All view.

noteNote
The configuration item relation types can be retrieved from the v_CIRelationTypes view.

v_CIRelationTypeMapping

Lists the configuration item elements, such as Baselines and Software Updates, the relation type value, and a description for the relation type.

The view can be joined to other desired configuration management views by using the RelationType column.

v_CIRelationTypes

Lists the relation type values, a description for the relation type, and whether the relation type is recursive.

The view can be joined to other desired configuration management views by using the RelationType column.

v_CITargetedCollections

Lists configuration items, by CI_ID, and the collection that the configuration item targets, by LocalCollectionID, CollectionID, and CollectionName.

The view can be joined to other desired configuration management views by using the CI_ID, LocalCollectionID, and CollectionID columns.

v_CITargetedMachines

Lists configuration items, by CI_ID, and the Configuration Manager clients that the configuration item targets, by ResourceID.

The view can be joined to other desired configuration management views by using the CI_ID and ResourceID columns.

v_CITypes

Lists the configuration item types, by CIType_ID, and the type name. For example, software updates have a CIType_ID of 1, configuration baselines have a CIType_ID of 2, and so on.

The view can be joined to other views by using the CIType_ID column, but it is more likely that this view will be used as a reference when filtering configuration item data retrieved from configuration item views in the report SQL statement.

v_CIValidationSeverity

Lists the configuration item validation severity, by Severity, and a description, such as Informational, Warning, and Error.

It is unlikely that this view will be joined to other views, but it can be used as a reference when filtering configuration item data retrieved from configuration item views in the report SQL statement.

v_ConfigurationItems

Lists the configuration items in the Configuration Manager site hierarchy, by CI_ID and CI_UniqueID, and details about the configuration item such as configuration item type ID, configuration item version, date the configuration item was created and last modified, whether it is part of a bundle, whether it is a hidden configuration item, whether it has been deployed, whether it is enabled, the source site for the configuration item, and so on. When creating SQL statements for the desired configuration management, software updates, and operating system deployment features, this view will most often be joined to other views when creating the report SQL statement.

The view can be joined to other views by using the CI_ID, CI_UniqueID, ModelName, SDMPackage_ID, and CIType_ID columns.

v_LocalizedCategories

Lists the configuration item category instances in the Configuration Manager site hierarchy, by CategoryInstanceID and CategoryInstanceName, and the locale for the category instance. Category instances consist of languages, update categories, products, product families, custom categories for desired configuration management, and so on.

The view can be joined to other views by using the CategoryInstanceID column.

v_LocalizedCategories_SiteLoc

Lists the configuration item category instances for the local Configuration Manager site, by CategoryInstanceID and CategoryInstanceName, the locale that the category instance is for, and the localized category instance name, which is the locale and category instance name combined. Category instances consist of languages, update categories, products, product families, custom categories for desired configuration management, and so on.

The view can be joined to other views by using the CategoryInstanceID column.

v_LocalizedCIProperties

Lists the configuration items in the Configuration Manager site hierarchy, by CI_ID, that contain localized properties, such as the display name, description, and informative URL for a software update.

The view can be joined to other views by using the CI_ID column.

v_LocalizedCIProperties_SiteLoc

Lists the configuration items for the local Configuration Manager site, by CI_ID, that contain localized properties, such as the localized properties for a software update. The information includes the locale ID, display name, description, and configuration item informative URL.

The view can be joined to other views by using the CI_ID column.

v_SDMErrorCategories

Lists the SDM error categories, by Category, and the description for the error.

It is unlikely that this view will be joined to other views.

v_SDMLocalizedData_SiteLoc

Lists the SDM packages, by ModelName, the SDM package version, the localeID for the data in the SDM package, and the localized data in XML format.

The view can be joined to other views by using the ModelName column.

Desired Configuration Management Status Views

The desired configuration management status views contain information about the compliance, evaluation, and enforcement state of configuration items. For more information about the status views, see Status Views. The status views that contain desired configuration management information are described in the following table.

 

Desired Configuration Management View Description

v_CIAssignmentStatus

Lists the enforcement and evaluation state messages received from Configuration Manager client computers for all assigned configuration items, including assigned software update deployments and assigned configuration baselines. The assignment ID, resource ID, last enforcement state message ID, last evaluation state message ID, and so on are provided.

The view can be joined to other views by using the AssignmentID and ResourceID columns.

v_CIComplianceHistory

Lists the configuration items, by CI_UniqueID and CI_ID, that are configuration baselines or a configuration item in a configuration baseline, have been assigned to a Configuration Manager client (listed by ResourceID), and it lists compliance information for the configuration item. The information includes the compliance start and end dates, whether the configuration item is applicable to the client, whether the client is compliant for the configuration item, and so on.

The view can be joined to other views by using the CI_UniqueID, CI_ID, and ResourceID columns.

v_CIComplianceStatusDetail

Lists the configuration items, by CI_ID and CI_UniqueID, that are in a configuration baseline, have been assigned to a Configuration Manager client (listed by ResourceID), and have a state value of Non-Compliant.

The view can be joined to other views by using the CI_ID, CI_UniqueID, ResourceID, and ModelName columns.

v_CICurrentComplianceStatus

Lists the compliance and enforcement states for configuration items, by configuration item ID, as well as the resource ID, whether the configuration item is applicable to the resource, and information related to the compliance and evaluation of the configuration item.

The view can be joined to other views by using the CI_ID, ResourceID, CI_UniqueID, ModelName, ComplianceState, and LastEnforcementMessageID columns. The ComplianceState column provides the state ID for state messages with a topic type of 401. The LastEnforcementMessageID column provides the state ID for state messages with a state message topic type of 402.

v_DCMClientStatusInformation

Lists all possible desired configuration management client states.

It is unlikely that this view will be joined to other views.

noteNote
This view was introduced in Configuration Manager 2007 Service Pack 1.

Desired Configuration Management Status Summarizer Views

The desired configuration management status summarizer views provide summary information for configuration item assignments and configuration baselines. For more information about the status summarizer views, see Status Views. The status summarizer views that contain desired configuration management information are described in the following table.

 

Desired Configuration Management View Description

v_AssignmentSummaryPerTopic

Lists the assignments, by assignment ID, the type of assignment state message, the state ID for the type, the count of Configuration Manager client computers that are in the assignment state, and the total count of client computers that have been targeted for the assignment.

The view can be joined to other views by using the AssignmentID column.

noteNote
There are three deployment assignment states. A state type of 300 is assignment compliance, type 301 is assignment enforcement, and type 302 is assignment evaluation. You can find a list of the state IDs by looking in the v_StateNames view.

v_CIComplianceSummary

Lists the desired configuration management configuration baselines, by CI_ID, and the count of Configuration Manager client computers that have been targeted, how many clients are compliant, how many have failed the compliance evaluation, how many are noncompliant, and so on.

The view can be joined to other views by using the CI_ID and CI_UniqueID columns.

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft