select Name, ClientVersion, ResourceDomainORWorkgroup, LastLogonUserDomain, LastLogonUserName, ADSiteName, IPAddresses, ResourceId, ResourceType from SMS_R_System where Client = 1 and ClientVersion < ‘5.00’ and ClientType != 3

Results: