DickyDck

Hello everyone, I've been using this site for years, and never had to post anything since I have always found the answer! But here is one that kinda goes along this same thread. I am trying to create a script for SCCM that polls an OU for all the users, then queries the users machine, and then takes that machine and places it in a collection, here is what I've found but I keep getting a syntax error... 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.UserName in (select UniqueUserName from SMS_R_User where UserOUName = "Domain/OU” ) I think I might have a space or something wrong somewhere, but the error is in the lower half of the script since everything seems to be fine if I cut out this part.... inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.UserName in (select UniqueUserName from SMS_R_User where UserOUName = "Domain/OU” ) Is there something I need to change that anyone can see? Thanks in advance, you all Rock!