About SQL Views used by Client Status Reporting

Atualizada: Junho de 2008

Aplica-se a: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3

noteNota
As informações neste tema aplicam-se apenas ao Configuration Manager 2007 R2 e ao Configuration Manager 2007 R3.

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

Consulte Também

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.

Conteúdo da Comunidade

Mostrar: