Topic last updated—June 2008
 Note |
|---|
| The information in this topic applies only to Configuration Manager 2007 R2. |
Client status reporting in Configuration Manager 2007 R2 includes a number of predefined reports that help you to examine the status of client computers in your enterprise. You can also use create your own custom reports by querying the SQL database.
v_CH_ClientSummary SQL View
The following fields contain summarized client status information for all computers:
| Field name | Description |
|---|---|
|
MachineID |
Unique machine ID identifier |
|
NetBiosName |
Name of the client |
|
SiteCode |
The site code |
|
Version |
Client version installed |
|
LastDDR |
Time of the last heartbeat discovery |
|
LastHW |
Time of the last hardware inventory scan |
|
LastSW |
Time of the last software inventory scan |
|
LastStatusMessage |
Time of the last status message |
|
LastPolicyRequest |
Time of the last policy request |
|
LastSuccessfulPing |
Last time ping was successfully able to reach the client |
|
LastPingTime |
Last time ping was attempted for the client |
|
LastPingResult |
Result of the last ping test |
|
ClientDeployed |
Whether or not client is deployed based on FSP data |
|
ClientAssigned |
Whether or not client is assigned based on FSP data |
|
ClientFrameworkHealthy |
Whether or not client communication framework is healthy. Not healthy usually means certificate issues |
|
IsActiveDDR |
Whether or not client is active by last heartbeat discovery |
|
IsActiveHW |
Whether or not client is active by last hardware scan |
|
IsActiveSW |
Whether or not client is active by last software scan |
|
IsActivePolicyRequest |
Whether or not client is active by last policy request |
|
IsActiveStatusMessages |
Whether or not client is active by last status message |
|
Obsolete |
Whether or not client is obsolete. 1 means an obsolete client |
v_CH_ClientSummaryHistory SQL View
The following fields contain client status data collected over time. This data is usually collected once a day.
| Field name | Description |
|---|---|
|
Date |
Date of the summarization |
|
ClientsTotal |
Total number of clients (not including obsolete clients) |
|
ClientsActive |
Total number of clients considered active by any discover mechanism |
|
ClientsActiveDDR |
Total number of clients active via heartbeat discovery |
|
ClientsActiveHW |
Total number of clients active via hardware scan |
|
ClientsActiveSW |
Total number of clients active via software scan |
|
ClientsActivePolicyRequest |
Total number of clients active via policy request |
|
ClientsActiveStatusMessage |
Total number of clients active via status messages |
v_CH_PolicyRequestHistory SQL View
The following fields contain policy request information per client per day. This can be used to determine how many unique clients requested policy within a given number of days.
| Field name | Description |
|---|---|
|
MachineID |
Unique client ID |
|
RequestTime |
Date of the policy request |