We're in the process of OSD and a complete change of naming structure. Currently I have a collection based on an OU using the follwing 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/OU" It works fine, however it shows all client. I only want it to show clients the start with a specific name. Is this possible? TIA

Hello - try out 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 inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_R_System.SystemOUName = "Domain/OU" and SMS_G_System_SYSTEM.Name like "WKP%" where WKP is the first three letters you wanted to specifyAnoop C Nair

Hi Andrew, Yes, it is possible. add "and SMS_R_SYSTEM.Name0 like "Name%" to your query at the end. Here replace Name with your specific name. 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/OU" and SMS_R_SYSTEM.Name0 like "Name%" Regards, Madan