Change "inner join" to "left join". William
From: [email protected] on behalf of Burke, John Sent: Thursday, May 30, 2013 10:28 To: [email protected] Subject: [mssms] systems that can't run updates - hi, a simple query. When I open up resource explorer some of the systems that can't get their updates via sccm have no "windows update agent version" in resource explorer. I wanted to get a quick count of how many systems are in that state. "select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_WINDOWSUPDATEAGENTVERSION on SMS_G_System_WINDOWSUPDATEAGENTVERSION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_WINDOWSUPDATEAGENTVERSION.Version is null " not sure why that is returning a count of 0. Something very strange.
