Hi! I am looking into creating a query based collection that picks out all my server 2008 R2 machines that HAS a client installed. I am using the following query to pick out my 2008 R2 servers: select SMS_R_System.Name, SMS_R_System.SMSAssignedSites, SMS_R_System.IPAddresses, SMS_R_System.IPSubnets, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ResourceDomainOrWorkgroup, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonUserName, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceId, SMS_R_System.NetbiosName from SMS_R_System where SMS_R_System.OperatingSystemNameandVersion like "%Server 6.1%" My question is, how do I alter this query to include only 2008 R2 servers that has the client installed? Thanks :)

Just add "and SMS_R_System.Client = 1"Torsten Meringer | http://www.mssccmfaq.de