Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Status 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

Microsoft System Center Configuration Manager 2007 status messages report information about Configuration Manager 2007 component behavior and data flow and are categorized by severity and type. State messages are sent by Configuration Manager 2007 clients to site systems based on important changes of state, providing a snapshot of the state of a process at a specific time. Status summarizers produce summaries of the status and state messages and provide a snapshot of status and health of site systems, components, software updates compliance, and so on.

Status message instances consist of properties that are stored in the database, which are represented primarily by the v_StatusMessage view, and message strings stored in dynamic-link library (DLL) files. When you view a message by using the Configuration Manager console, Status Message Viewer, and the Status Message Details page in Report Viewer, Configuration Manager creates the instance of status messages by combining the various parts.

The following sections provide detailed information about status message views, state message views, and status summarizer views.

Status Message Views

The status views are described in the following table.

 

Status View Description

v_AdvertisementStatusInformation

Lists all advertisement status message IDs, the message state, and the message name, such as succeeded, expired, failed, and retrying. The view is also listed and described in the Software Distribution Views topic.

The view can be joined to other advertisement status views by using the MessageID column.

v_ClientAdvertisementStatus

Lists all advertisements with the associated status for system resources that have been targeted. The view is also listed and described in the Software Distribution Views topic.

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

v_ClientMessageStatistics

Lists all Configuration Manager clients, by resource ID, the last time the client sent and processed a status message, and the last time a resynchronization was issued and completed on the client.

This view can be joined to other views by using the ResourceID column.

v_ClientUpdateAdvertisementStatus

Lists all client update advertisements, by advertisement ID, and the status for system resources that have been targeted by the advertisement. The view is also listed and described in the Software Distribution Views topic.

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

v_DCMClientStatusInformation

Lists all possible desired configuration management client states. The view is also listed and described in the Desired Configuration Management Views topic.

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

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

v_PackageStatus

Lists the status for all software distribution and software update deployment packages, as well as the package server location, last update time, and so on. The view is also listed and described in the Software Distribution Views topic.

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

v_PeerDPStatusInfo

Lists the peer distribution point states and associated state names. The view is also listed and described in the Software Distribution Views topic.

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

v_ServerMessageStatistics

Lists the site system servers, the associated site code, when the last heartbeat occurred, and how long the heartbeat took to process. The view is also listed and described in the Site Views topic.

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

v_StatMsgAttributes

Lists the attributes for all status messages (for example, package ID, collection ID, user name, object GUID, and so on).

The view can be joined to the v_StatusMessage and v_StatMsgInsStrings views by using the RecordID column.

v_StatMsgInsStrings

Lists the status insertion strings for all status messages.

The view can be joined to the v_StatusMessage and v_StatMsgAttributes views by using the RecordID column.

v_StatMsgModuleNames

Lists the status message module names with associated module DLL name. By default, Configuration Manager has the SMS Client, SMS Provider, and SMS Server module names.

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

v_StatusMessage

Lists information about all status messages, including status message ID, time of status message, severity, site code, and so on.

The view can be joined to the v_StatMsgAttributes and v_StatMsgInsStrings views by using the RecordID column, and to other views by using the MachineName column.

v_TaskExecutionStatus

Lists the status for operating system deployment task sequence steps, as well as the advertisement ID, resource ID, action name, and so on. The view is also listed and described in the Operating System Deployment Views topic.

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

v_WOLCommicationErrorStatus

Lists the Wake on LAN error status messages, as well as the time of the error, batch ID, object type, ID, and error code. The view is also listed and described in the Wake On LAN Views topic.

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

State Views

The state views list the state messages sent by Configuration Manager 2007 clients to site systems and can generally be joined to system data, other state message views, deployment assignment views, and so on. The Configuration Manager states are listed in the v_StateNames view. When creating reports by using state views, you will likely want to join the v_StateNames view with another state view by using the StateType and StateID columns to retrieve the friendly names for the state and to use the v_StateNames view to determine the criteria to filter the SQL statement. Each state message type has multiple state IDs, which start at 1 for each message type. When joining to a view that contains information for more than one state type, you will need to either join to the other view by using both the StateType and StateID columns or join to the other view by using the StateID column and filter the query with for the specific StateType. For example, if you join to another view by using the StateID column, you could filter the results by StateType=300. For more information about the state messages in Configuration Manager 2007, see State Messages in Configuration Manager 2007 (http://go.microsoft.com/fwlink/?LinkId=124800). The state views are listed and described in the following table.

 

State View Description

v_AssignmentState_Combined

Lists the last state message received from Configuration Manager client computers for assigned software update deployments, including the assignment ID (deployment ID), resource ID, state type, and so on. The view is also listed and described in the Software Updates Views topic.

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

v_AssignmentStatePerTopic

Lists the last state message for each state type received from Configuration Manager client computers for assigned software update deployments, including assignment ID (deployment ID), resource ID, state type, and so on. The view is also listed and described in the Software Updates Views topic.

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

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, the last enforcement state message ID, the last evaluation state message ID, and so on are provided. The view is also listed and described in the Desired Configuration Management Views topic.

The view can be joined to other views by using the AssignmentID, ResourceID, LastEnforcementMessageID, and LastEvaluationMessageID columns. The LastEnforcementMessageID column provides the state ID for state messages with a topic type of 402. The LastEvaluationMessageID column provides the state ID for state messages with a topic type of 400.

v_CIComplianceHistory

Lists the configuration items, by CI_UniqueID and CI_ID, that are configuration baselines or configuration items within a configuration baseline, that have been assigned to a Configuration Manager client, listed by ResourceID, and 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 is also listed and described in the Desired Configuration Management Views topic.

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 is also listed and described in the Desired Configuration Management Views topic.

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 is also listed and described in the Desired Configuration Management Views topic.

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_ClientDeploymentState

Lists all Configuration Manager clients, by SMSID, and the last client deployment state reported, as well as the fully qualified domain name (FQDN), NetBIOS name, assigned site code, client version, and so on. The view is also listed and described in the Client Deployment Views topic.

The view can be joined to other views by using the SMSID, FQDN, NetBiosName, and LastMessageStateID columns. The LastMessageStateID column contains the state ID for topic type 800. The Configuration Manager states are listed in the v_StateNames view.

v_ClientHealthState

Lists all Configuration Manager clients, by SMSID, the last client health state reported for each state type, the fully qualified domain name (FQDN), NetBIOS name, assigned site code, health type, health state, health state name, and so on. The view is also listed and described in the Client Health Views topic.

The view can be joined to other views by using the SMSID, FQDN, NetBiosName, HealthType, and HealthState columns. The HealthType column contains the topic type and the HealthState column contains the state ID. Client health state messages have a state type from 1000 to 1004. The Configuration Manager states are listed in the v_StateNames view.

v_DeviceClientDeploymentState

Lists all Configuration Manager mobile device clients, by device client ID, NetBIOS name, and device ID, and the last device deployment state reported, as well as the assigned site code, device client version, and so on. The view is also listed and described in the Mobile Device Management Views and Client Deployment Views topics.

The view can be joined to other views by using the DeviceClientID, which contains the same information as the SMS_Unique_Identifier0 column in the v_R_System view, DeviceNetBiosName, and DeviceDeploymentState columns. The DeviceDeploymentState column contains the state ID for topic type 800. The Configuration Manager states are listed in the v_StateNames view.

v_DeviceClientHealthState

Lists all Configuration Manager mobile device clients, by device client ID, NetBIOS name, and device ID, and the health state of the device, as well as the assigned site code, owner name, and so on. The view is also listed and described in the Mobile Device Management Views and Client Health Views topics.

The view can be joined to other views by using the DeviceClientID, which contains the same information as the SMS_Unique_Identifier0 column in the v_R_System view, DeviceNetBiosName, DeviceID, HealthType, and HealthState columns. The HealthType column contains the topic type and the HealthState column contains the state ID. Client health state messages have a state type from 1000 to 1004. The Configuration Manager states are listed in the v_StateNames view.

v_StateNames

Lists all states that can be reported by Configuration Manager clients by topic type, state ID, state name, and state description. Each state topic type defines a specific function, and each topic type contains multiple state IDs.

The view can be joined to other views by using the TopicType and StateID columns.

v_Update_ComplianceStatusAll

Lists the detection state for all software updates that have been scanned for compliance on Configuration Manager clients, as well as the resource ID of the client, last enforcement state ID, enforcement source, last status check time, and so on. The v_Update_ComplianceStatusAll view combines information from the v_Update_ComplianceStatusReported and v_UpdateComplianceStatus_Unknown views. The view is also listed and described in the Software Updates Views topic.

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

v_Update_ComplianceStatusReported

Lists the detection state for all software updates that have been scanned for compliance on Configuration Manager clients, as well as the resource ID of the client, last enforcement state ID, enforcement source, last status check time, and so on. The v_Update_ComplianceStatusReported view combines information from the v_UpdateComplianceStatus and v_UpdateComplianceStatus_NotApplicable views. The view is also listed and described in the Software Updates Views topic.

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

v_UpdateAssignmentStatus

Lists the software update deployment assignments, the system resources that have been targeted, the last compliance state for the deployment, the last enforcement state for the deployments, the last evaluation state for the deployment, and so on. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the AssignmentID, ResourceID, LastComplianceMessageID, LastEnforcementMessageID, and LastEvaluationMessageID columns. The LastComplianceMessageID column provides the state ID for state messages with a topic type of 300. The LastEnforcementMessageID column provides the state ID for state messages with a topic type of 301. The LastEvaluationMessageID provides the state ID for state messages with a topic type of 302.

v_UpdateAssignmentStatus_Live

Lists the software update deployment assignments, the system resources that have been targeted, the last compliance state for the deployment, the last enforcement state for the deployments, the last evaluation state for the deployment, and so on. The v_UpdateAssignmentStatus_Live view contains a subset of information from the v_UpdateAssignmentStatus view. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the AssignmentID, ResourceID, LastComplianceMessageID, LastEnforcementMessageID, and LastEvaluationMessageID columns. The LastComplianceMessageID column provides the state ID for state messages with a topic type of 300. The LastEnforcementMessageID column provides the state ID for state messages with a topic type of 301. The LastEvaluationMessageID provides the state ID for state messages with a topic type of 302.

v_UpdateComplianceStatus

Lists the detection state for all software updates that have been scanned for compliance on Configuration Manager clients, as well as the resource ID of the client, last enforcement state ID, enforcement source, last status check time, and so on. The view is also listed and described in the Software Updates Views topic.

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

v_UpdateComplianceStatus_NotApplicable

Lists the software updates, by configuration item ID, that have been scanned for compliance on Configuration Manager clients where the software update is not applicable on the computer. The view is also listed and described in the Software Updates Views topic.

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

v_UpdateComplianceStatus_Unknown

Lists the software updates, by configuration item ID, and system resources, by resource ID, that have been scanned for compliance and the compliance state is unknown. The view is also listed and described in the Software Updates Views topic.

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

v_UpdateListStatus_Live

Lists all update lists, by CI_ID, and the associated compliance state for Configuration Manager client computers that are active. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the CI_ID, ResourceID, and Status columns. The Status column provides the state ID for state messages with a topic type of 500.

noteNote
Update lists have a configuration item type of 9.

v_UpdateScanStatus

Lists the Configuration Manager client computers, by resource ID, that have scanned for software updates compliance and the last scan state, as well as the last scan time, last error code, last Windows Update Agent version, and so on. The view is also listed and described in the Software Updates Views topic.

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

noteNote
The LastScanState column provides the state ID for state messages with a topic type of 501.

v_UpdateState_Combined

Lists the detection state for software updates that are not required on Configuration Manager client computers and the enforcement state for software updates that are required on Configuration Manager client computers, as well as the state ID, state time, enforcement source, and so on. The view is also listed and described in the Software Updates Views topic.

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

noteNote
A value of 402 in the StateType column is for enforcement state, and a value of 500 is for software update detection state.

Status Summarizer Views

Status summarizers produce summaries from status messages, state messages, and other data in the Configuration Manager site database. Status summaries are produced in real time as the summarizers receive status and state messages from Configuration Manager components and clients. You can use status summarizers to view a snapshot of the status and health of the site systems, components, advertisements, software updates compliance, client health, and so on.

Data in a status summary is classified as either a count or a state. A count is a tally of events that occurs over a specific period of time, such as the number of error status messages reported by a component since the beginning of the week. A state is the last known condition of something, such as the number of free bytes that is available for the Configuration Manager site database.

Each of the status summaries contains some state data. Only the Component Status and Advertisement Status summaries contain count data. The status summarizer views contain data such as the number of information, warning, and error messages for a site within a specified interval and the state of all components in a site at a specified interval.

Each of the status message summarizer views are listed and described in the following table.

 

Status Summary View Name Description

v_AdvertisementStatusRootSumm

Lists summary status for advertisement information, including the advertisement ID and advertisement status summarizer data, as well as package, program, and collection information. The view is also listed and described in the Software Distribution Views topic.

The view can be joined to other views by using the AdvertisementID, PackageID, and CollectionID columns.

v_AdvertisementStatusSummarize

Lists summary status for advertisement information, including the advertisement ID, site code, and advertisement status summary data. The view is also listed and described in the Software Distribution Views topic.

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

v_ApplicableUpdatesSummary

Lists the total count summary for the updates installed on clients for all applicable updates, as well as the update ID, update title, Q number, product, link for update information, and link for update download. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the ID, QNumbers, and Title columns.

v_ApplicableUpdatesSummaryEx

Lists the applicable software updates, by update ID, and the total count of software updates installed and required on client computers, as well as the bulletin ID, update title, Knowledge Base number, link for update information, unique update ID, and so on. The view is also listed and described in the Software Updates Views topic.

The view can be joined to other views by using the UpdateID and UniqueUpdateID columns.

noteNote
The UpdateID column references the configuration ID for the software update and is listed as the CI_ID in other views. The Counts column refers to the number of client computers that require the software update, and the IntalledCounts column refers to the number of client computers that have the software update installed.

v_AssignmentEnforcementSummaryPerUpdateAndState

Lists the software update deployments, by assignment ID, the software updates in the deployment, by CI_ID, the enforcement state name, the count of Configuration Manager client computers that are in the enforcement state, and the total count of client computers that have been targeted for the deployment. The view is also listed and described in the Software Updates Views topic.

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

noteNote
The enforcement states listed in this view have a state type of 402.

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 is also listed and described in the Desired Configuration Management Views topic.

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

noteNote
There are three deployment assignment states. 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_CH_ClientSummary

Lists summarized client status information for all Configuration Manager client computers, such as last heartbeat discovery, last hardware and software inventory scan, last policy request, whether there are possible certificate issues, and so on. The view is also listed and described in the Client Health Views topic.

The view can be joined to other views by using the MachineID, NetBiosName, and SiteCode columns.

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

v_CH_ClientSummaryHistory

Lists a summarization of the client status information for all Configuration Manager client computers, such as total number of clients, total number of clients that are active based on the last heartbeat discovery, hardware and software inventory scans, and so on. The view is also listed and described in the Client Health Views topic.

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

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

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, the count of client computers that are noncompliant, and so on. The view is also listed and described in the Desired Configuration Management Views topic.

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

v_ClientOfferSummary

Lists the software distribution advertisements, by OfferID, the count of Configuration Manager client computers that have been targeted, and the count of computers reporting not started, waiting, running, retrying, failed, and succeeded status for the advertisement. The view is also listed and described in the Software Distribution Views topic.

The view can be joined to other views by using the OfferID and PkgID columns.

v_ComponentSummarizer

Lists summary status information for all Configuration Manager components for different intervals. The view also provides the site code, server name, component name, the count of information, warning, and error messages, and so on. The information in this view contains the same information that is displayed in the Component Status node of the Configuration Manager console, but the view contains information for all display intervals. The view is also listed and described in the Site Views topic.

noteNote
The value in the Status column provides the current status for the component. A value of 0 indicates that the component is OK, a value of 1 indicates a warning state for the component, and a value of 2 indicates a critical state for the component.

The view can be joined to other views by using the SiteCode, MachineName, and ComponentName columns.

v_FileUsageSummary

Lists software metering summary status information for file usage by site. The view is also listed and described in the Software Metering Views topic.

The view can be linked by using the FileID column.

v_FileUsageSummaryIntervals

Lists software metering summary interval information for file usage. The view is also listed and described in the Software Metering Views topic.

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

v_INSTALLED_SOFTWARE_DATA_Summary

Lists the count of the installed software applications on Configuration Manager clients found through Asset Intelligence. This view contains the same source information as the v_GS_INSTALLED_SOFTWARE view, but provides summary information instead of listing the individual system resources. The view is also listed and described in the Asset Intelligence Views topic.

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

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_MonthlyUsageSummary

Lists the Configuration Manager client computers, by ResourceID, and the usage summary for metered files, as well as the logged-on user name, usage time, and time of last usage. The view is also listed and described in the Software Metering Views topic.

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

v_NAPRestrictionErrorSummary

Lists Network Access Protection (NAP) error messages that have been reported and the count of errors over the last day, last 7 days, and last 30 days. The view is also listed and described in the Network Access Protection Views topic.

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

v_NAPRestrictionSummary

Lists the software updates, by CI_ID and CI_UniqueID, bulletin ID, article ID, and the count of NAP restrictions over the last day, last 7 days, and last 30 days for the update. The view is also listed and described in the Network Access Protection Views topic.

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

v_NAPSystemInfo

Lists the total count of Configuration Manager 2007 clients, how many clients can have the NAP client installed on them, how many clients are not capable of having the NAP client installed on them, how many clients already have the NAP client installed on them, and how many clients are in a restricted state. The view is also listed and described in the Network Access Protection topic.

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

v_PackageStatusDetailSumm

Lists all packages, by PackageID, the originating site code, package name, site name, source version, the date for the summary information, the targeted count for each package, and the count for installed, retrying, and failed status. The view is also listed and described in the Software Distribution Views topic.

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

v_PackageStatusDistPointSumm

Lists all packages, by PackageID, and the installation status for the package source files on all associated distribution points. The view also provides information such as the site code, path to the distribution point, path to source location, time of last copy, and so on. The view is also listed and described in the Software Distribution Views topic.

The view can be joined to other views by using the PackageID and ServerNALPath columns.

v_PackageStatusRootSummarizer

Lists all packages, by PackageID, the package name, source version, source date, the source site, size of the source files, the targeted count for each package, and the count for installed, retrying, and failed status. The view is also listed and described in the Software Distribution Views topic.

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

v_SiteDetailSummarizer

Lists status summary information for all Configuration Manager sites, by SiteCode, for different intervals. The view also provides the site name, site version, interval, the count of information, warning, and error messages, and so on. The information in this view contains the same information that is displayed in the Site Status node of the Configuration Manager console, but the view contains information for all display intervals. The view is also listed and described in the Site Views topic.

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

noteNote
The value in the Status column provides the current status for the site. A value of 0 indicates that the site is OK, a value of 1 indicates a warning state for the site, and a value of 2 indicates a critical state for the site.

v_SiteSystemSummarizer

Lists status summary information for all Configuration Manager sites systems for different intervals. The view also provides the object location, the site role for the site system, total disk space, free disk space, and percentage of free disk space for the site system, the time of the last status reported, and whether the site system is available. The information in this view contains the same information that is displayed in the Site System Status node of the Configuration Manager console. The view is also listed and described in the Site Views topic.

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

v_SummarizationInterval

Lists the status summary interval.

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

v_SummarizerRootStatus

Lists the root summary status, which is the same status displayed on the System Status node of the Configuration Manager console.

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

v_SummarizerSiteStatus

Lists the site summary status, which is the same status displayed for the <site code> - <site name> node of the Configuration Manager console. The view is also listed and described in the Site Views topic.

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

v_SummaryTasks

Lists the tasks, by name and command, used to summarize Configuration Manager information, as well as the run interval, last run duration, when the task last completed successfully, next start time, and so on.

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

v_Update_ComplianceSummary

Lists all software updates, by CI_ID, the last time summarization was run, the total count of client computers, the count of client computers reporting unknown, not applicable, missing (required), and present (already installed) states, and so on. The view is also listed and described in the Software Updates Views topic.

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

v_Update_ComplianceSummary_Live

Lists all software updates, by CI_ID, the last time summarization was run, the total count of client computers, the count of client computers reporting unknown, not applicable, missing (required), and present (already installed) states, and so on. The view is also listed and described in the Software Updates Views topic.

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

v_Update_DeploymentSummary_Live

Lists all software updates, by CI_ID, in active software update deployments, listed by AssignmentID, and summarized state reported by targeted clients. The view includes the target collection ID and name; the time of the last summarization; the total number of client computers targeted; the count of client computers reporting unknown, not applicable, missing (required), and present (already installed) states; the number of clients that have installed the software update and failed to install the update; and so on. The view is also listed and described in the Software Updates Views topic.

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

v_UpdateDeploymentSummary

Lists all software updates, by CI_ID, in software update deployments, listed by AssignmentID, and summarized state reported by targeted clients. The view includes the target collection ID and name; the time of the last summarization; the total number of client computers targeted; the count of client computers reporting unknown, not applicable, missing (required), and present (already installed) states; the number of clients that have installed the software update and failed to install the update; and so on. The view is also listed and described in the Software Updates Views topic.

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

v_UpdateEnforcementSummaryPerCollection

Lists the summary state for all software updates that have been deployed. The view provides the software update, by CI_ID, target collection, collection name, and summarized enforcement state reported by clients in the collection. The view is also listed and described in the Software Updates Views topic.

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

v_UpdateSummaryPerCollection

Lists the summary state for all software updates and the compliance state per collection. The view includes the software update, by CI_ID; target collection ID and name; the time of the last summarization; the total number of client computers targeted; the count of client computers reporting not applicable, missing (required), present (already installed), and unknown states; and so on. The view is also listed and described in the Software Updates Views topic.

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

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.