I'm in the process of upgrading from SMS 2003 to ConfigMgr 07 but I'm having trouble working out a quick way of displaying which Clients have been upgraded to ConfigMgr. Does anyone have a Query that will show me this?

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
The following query will show which Clients have been upgraded to ConfigMgr 07:

select SMS_R_SYSTEM.Name,SMS_R_SYSTEM.ClientVersion,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ClientVersion > "4%"