Client health views contain information about the client health components on Configuration Manager 2007 client computers, when the client computer last requested the client health policy, and so on. There are also status views that contain information about the health of Configuration Manager 2007 client computers, such as when the client last scanned for hardware and software inventory, the last policy request, the result of the last ping request, and so on. Client health and client health status views will most often be joined to other views by using the MachineID, ResourceID, NetbiosName, HealthStatus, and HealthType columns.

The following sections provide detailed information about client health views and client health status views.

Client Health Views

The client health views are described in the following table.

Client Health View Description

v_CH_PolicyRequestHistory

Lists all Configuration Manager 2007 client computers and the time of the last policy request, which can be used to determine how many unique clients have requested policy within a given number of days.

The view can be joined to other views by using the MachineID column, which contains the same information as the ResourceID column in other views.

Note
This view was introduced in Configuration Manager 2007 SP1.

v_GS_SYSTEMHEALTHAGENT

Lists information about the client health components found on Configuration Manager clients.

The view can be joined with other views by using the ResourceID column.

Note
This view was introduced in Configuration Manager 2007 SP1.

Client Health Status Views

The client health status views contain status and status summary information about the health of Configuration Manager client computers. For more information about the status views, see Status Views. The status views that contain client health information are described in the following table.

Client Health Status View Description

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 can be joined to other views by using the MachineID and NetBiosName columns. The MachineID column in this view contains the same information as the ResourceID column in other views.

Note
This view was introduced in Configuration Manager 2007 Service Pack 1 (SP1).

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.

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

Note
This view was introduced in Configuration Manager 2007 SP1.

v_ClientHealthState

Lists all Configuration Manager clients, by SMSID, and the last client health state reported for each state type, as well as the NetBIOS name, fully qualified domain name (FQDN), assigned site code, health type, health state, health state name, and so on.

The view can be joined to other views by using the SMSID, NetBiosName, HealthType, and HealthState columns. The SMSID column contains the same information as the SMS_UniqueIdentifier0 column in the v_R_System view. The HealthType column in this view contains the same information as the TopicType column in the v_StateNames view and the HealthState column in this view contains the same information as the StateID column in the v_StateNames status view. Client health state messages have a state type from 1000 to 1004. 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. This status view is also listed and described in the Mobile Device Management Views topic.

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

See Also