I get an error when trying to do the exclude systems in another container
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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Roles not like "%Domain_Controller%" and SMS_G_System_SYSTEM.Name not in (select name from SMS_CM_RES_COLL_STE00043)
The last line after Domain_Controller is what I added per the other posts. I'm not sure what I'm doing I don't understand SQL at all.
Codis