Can you help me create a collection based on a AD computer OU but exludes a couple of machines from that OU as well? Any help would be appreciated. Margie

Create a colleciton which contains the machine you want to exclude. Note colleciton ID(xxxxxxxx).. Then create a collection using below query - 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 where SMS_R_System.SystemOUName = "domain.COM/OU1" and resourceid not in (Select resourceID from sms_cm_res_coll_xxxxxxxx) Replace Domain.com woth your domain name, "OU1" with OU name, and xxxxxxxx with your collection ID.-- Vinayak Sharma

Hi Vinayak I tried same method to exclude one subnet range from AD site base collection its work for me 1. Create one collection based on Subnet (which you want to exclude from AD Site based collection) 2. Query for AD Site based collection (where you want to exclude IP subnet) 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 where SMS_R_System.ADSiteName = "XXXXXX" and resourceid not in (Select resourceID from sms_cm_res_coll_YYYYYYY) Note : XXXXX -> AD Site name YYYYYY -> Subnet base collection Id BR// Praveen Sharma B.Tech (E&C), MCSE,MCTS (Exchange)