SMS 2003: OK, I've got a collection that is working and doing what I want it to do, but I'm curious as to how it's doing it. I've created a collection that has members of an AD OU. It seems that by default this is recursive down the OU hierarchy. It's similar to this:
select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_ System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_Sy stem.Client from SMS_R_System WHERE SMS_R_System.SystemOUName = "acme.com/acme-HO/Servers/Test-Servers" I'm surprised this is the default knowing SMS. In this instance that is perfect, but what if I didn't want it to be recursive? How would I handle that in the query? Anyone know? For example say this is my OU hierarchy: SERVERS ----DEV ----TEST --------USA --------EUROPE ----PROD What if I wanted to target just the TEST OU? With the way the query seems to work in SMS, it would bring back all servers in the TEST, USA, and EUROPE OUs. Thanks Chris Chris Bodnar, MCSE Sr. Systems Engineer Distributed Systems Service Delivery - Intel Services Guardian Life Insurance Company of America Email: [email protected] Phone: 610-807-6459 Fax: 610-807-6003 ----------------------------------------- This message, and any attachments to it, may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are notified that any use, dissemination, distribution, copying, or communication of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by return e-mail and delete the message and any attachments. Thank you. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
