2 weeks back,working on patching issues in SMS 2003 which are having some trouble.there are lot of systems which failed the patches due to windows update agent doesnt exisit on the machines(identified the cause because of this) more information look here .It is bit hard to find the systems by looking at resource explorer and finding if it has latest windows update agent or not ? so just create a collection and advertise the package( windows update agent) on to this collection to get the good success rate for patching.
select ResourceId, ResourceType, Name, SMSUniqueIdentifier, ResourceDomainORWorkgroup, Client from SMS_R_System where ResourceId not in (select ResourceID from SMS_G_System_WINDOWSUPDATEAGENTVERSION)
Note:make sure that,windows update agent property is enabled(to collect this data from clients ) in your sms_def.mof file .
