Compliance Settings Views in Configuration Manager

 

Updated: January 1, 2014

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

The Configuration Manager compliance settings views contain information about the compliance of devices 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 compliance settings views contain information about the configuration baselines in the site, which configuration baselines store information about configuration items, 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 compliance settings views, compliance settings status views, and compliance settings status summarizer views.

Compliance Settings Views

There are many compliance settings views, and it can sometimes be difficult to find the information that you need for your report SQL statement. The following are some of the key compliance settings views and columns:

• CI_ID column – Commonly used to join compliance settings views

• v_ConfigurationItems view - Used to retrieve information about the configuration items in the site.

• v_CategoryInfo and v_LocalizedCIProperties views - Often be used to retrieve additional information about the configuration items.

• AssignmentID column and the v_CIAssignment view - Used to retrieve information about the configuration item deployments.

• v_CIAssignmentToCI view - Can be used as the link between the v_ConfigurationItems and v_CIAssignment views.

• v_CIAssignmentTargetedMachines view - can be used as the link between the v_CIAssignment view and the views that contain resource information, such as the v_R_System view.

The compliance settings views are described in the following table.

Compliance settings view	Description
v_AssignmentTargetedCIs	Lists the assignment ID, CI_ID and unique assignment ID for each deployed configuration item. This view can be joined to other views by using the CI_ID and AssignmentID columns.
v_BaselineTargetedComputers	Lists the clients, by ResourceID, to which a configuration baseline has been deployed, by CI_ID. This view displays only configuration baselines (CI_Type = 2). This view can be joined to other views by using the CI_ID and ResourceID 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 the parent category. This view contains the same source data as the v_CategoryInstances view, but it displays more columns. This 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. This 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. This 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. This view can be joined to other views by using the CI_ID and CI_UniqueID columns.

Compliance settings view	Description
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 configuration item deployments by AssignmentID, Assignment_UniqueID, and AssignmentName that are active in the Configuration Manager hierarchy, including the deployment description, collection ID and name that is targeted by the deployment, start time, enforcement deadline, whether the deployment is an update deployment, and other details about the deployment. The view can be joined to other 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 deployments, 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 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 deployments, 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 deployments, by AssignmentID, and the configuration items, by CI_ID, that are in the deployment. For example, if the deployment 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. Note 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 value of 0. For example, 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. Note 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, if 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. Note The configuration item relation types can be retrieved from the v_CIRelationTypes view.
v_CIRelationTypeMapping	Lists the configuration item elements, such as configuration baselines and software updates, the relation type value, and a description for the relation type. The view can be joined to other compliance settings 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 compliance settings 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 compliance settings 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 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 possible configuration item validation severities, 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.
v_SMSConfigurationItems	This view can be joined to other views by using the CI_ID and ModelID columns.
v_CIRules	Lists all rules that have been created in the Configuration Manager site. Includes the rule name, ID, and description. This view can be joined to other views by using the CI_ID column.
v_CIRulesAll	Lists all configuration item rules that are currently being used in the Configuration Manager site. This view can be joined to other views by using the CI_ID column.
v_CISettingReferences	Lists all settings that are currently deployed in the Configuration Manager site. This view can be joined to other views by using the CI_ID column.
v_CISettings	Lists all available settings that can be used in the Configuration Manager site. This view can be joined to other views by using the CI_ID column.
v_CIToContent	Lists, by CI_ID, any content packages that are associated with a configuration item. This view can be joined to other views by using the CI_ID and Content_UniqueID columns.
v_CIComplianceStatusErrorDetail	Lists, by CI_ID, information about the last compliance message returned by clients that evaluated the configuration item for compliance. This includes the time the last message was received and information about settings contained in the configuration item. This view can be joined to other views by using the CI_ID column.
v_CIComplianceStatusReificationDetail	Lists, by model ID instances where Configuration Manager remediated settings on client devices. This includes the settings ID and the value of the setting before and after it was remediated. This view can be joined to other views by using the ModelID column.
v_CIConfigPointTypes	Lists the different system configuration point types by type and name. It is unlikely that this view will be joined to other views.
v_CIConflictCode	Lists the various error codes and descriptions that might be returned when configuration data contains conflicting settings. It is unlikely that this view will be joined to other views.
v_CIContentPackage	Lists each configuration item together with the ID of any associated packages. This view can be joined to other views by using the CI_ID, or PkgID columns.
v_SMS_CIRelation	Lists, by FromCIID, the relationships between configuration items. It is unlikely that this view will be joined to other views.
v_SMSCICurrentComplianceStatus	Lists compliance information for each configuration item that has been deployed. This includes whether the configuration item is applicable, it’s version, the last time it reported about compliance, and more. This view can be joined to other views by using the CI_CurrentComplianceStatusID column.
v_CI_CurrentErrorDetails	Lists, by record ID, the configuration items that have generated an error when they were evaluated for compliance. This includes the error type, information about the setting, and the error code. This view can be joined to other views by using the CI_ID column.
v_CIAppDependenceRelations	Lists information about the application dependencies that are currently active in deployment types. It is unlikely that this view will be joined to other views.
v_CIAssignmentToGroup
v_CIComplianceStatusComplianceDetail	Lists, by CI_ID, deployed configuration items, and the compliance status of each setting in the configuration item. This view can be joined to other views by using the CI_ID column.
v_CIComplianceStatusConflictsDetail	Lists details about conflicts that were found when configuration item settings and rules were evaluated for compliance. This includes the time of the last status, information about the settings and rules, and the conflict error code. This view can be joined to other views by using the ResourceID column.
v_CICurrentRuleDetail	Lists, by record ID, the current compliance status of configuration item rules. This view can be joined to other views by using the RecordID column.
v_CIErrorDetails	Lists information about configuration items that reported errors when they were evaluated for compliance. This includes information about the configuration item, its settings and rules, and details about the error that was generated. This view can be joined to other views by using the CI_ID and ResourceID columns.
v_CI_CurrentComplianceStatus	Lists, by CI_ID, the currently deployed configuration items, and detailed information about their current compliance status. This view can be joined to other views by using the CI_ID and ResourceID columns.
v_CIAssignmentStatusSummary	Lists details about the compliance status of currently deployed configuration data. This view can be joined to other views by using the AssignmentID column.
v_CIAssignmentSummary	Lists summary information for deployed configuration items, including the summarization time, success and failure statistics, requirements not met, and more. This view can be joined to other views by using the AssignmentID column.

Compliance Settings Status Views

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

Compliance settings 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 compliance settings client states. It is unlikely that this view will be joined to other views.

Compliance Settings Status Summarizer Views

The compliance settings status summarizer views provide summary information for configuration item deployments and configuration baselines. For more information about the status summarizer views, see Status and Alert Views in Configuration Manager. The status summarizer views that contain compliance settings information are described in the following table.

Compliance settings view	Description
v_AssignmentSummaryPerTopic	Lists the deployments, by assignment ID, the type of deployment state message, the state ID for the type, the count of Configuration Manager client computers that are in the deployment state, and the total count of client computers that have been targeted for the deployment. The view can be joined to other views by using the AssignmentID column. Note There are three deployment states. A state type of 300 is deployment compliance, type 301 is deployment enforcement, and type 302 is deployment evaluation. You can find a list of the state IDs by looking in the v_StateNames view.
v_CIComplianceSummary	Lists the compliance settings configuration baselines, by CI_ID, and the count of Configuration Manager client devices that have been targeted, how many clients are compliant, how many have failed the compliance evaluation, how many are noncompliant, and more. The view can be joined to other views by using the CI_ID and CI_UniqueID columns.

See Also

SQL Server Views in System Center 2012 Configuration Manager