SQL Query To Find Unhealthy Machines December 23, 2019October 10, 2008 by PaddyMaddy 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'
