SQL Query To Find Unhealthy Machines In The SMS Client Health Database

 

This SQL query will list all of the resources that are marked as Unhealthy as determined by the SMS client Health Utility.

 

SQL Query:

 

Select Distinct

Name 'Machine Name',

LastUser 'Last Logged On User',

WasOnline,

LastPingResult State,

Classification Status

From ClientHealthResults

 

Where LastPingResult Is Not Null

And Classification = 'UnHealthy'

 

 

Published Sunday, December 16, 2007 8:24 AM by dhite
Filed under:

Comments

No Comments