thanks, that's what I had to do, with excel as well, a bit messy due to the way this AD structure was originally set up, major housekeeping required lol: 104 OU's contain computer accounts, and 4400 computer objects in AD, some are nexted 5 OU's deep, madness!!!! (tring getting Excel to accurately dedupe that lol)
thanks again! 2009/8/26 Christopher Bodnar <christopher_bod...@glic.com> > I just did this with Dsquery and it required very little cleanup with > Excel to pull out the names of the OUs from the output. > > > > > > > > Chris Bodnar, MCSE > Sr. Systems Engineer > Distributed Systems Service Delivery - Intel Services > Guardian Life Insurance Company of America > Email: christopher_bod...@glic.com > Phone: 610-807-6459 > Fax: 610-807-6003 > ------------------------------ > > *From:* Don Guyer [mailto:don.gu...@prufoxroach.com] > *Sent:* Wednesday, August 26, 2009 9:33 AM > *To:* NT System Admin Issues > *Subject:* RE: DSQuery > > > > Clayton, > > > > If you pull a list of computer accounts using dsquery, it > will include the OU information by default. > > > > Dsquery computer > computers.csv > > > > I was just messing with this command yesterday If you > Google dsquery there’s a ton of info. > > > > > > Don Guyer > > Systems Engineer - Information Services > > Prudential, Fox & Roach/Trident Group > > 431 W. Lancaster Avenue > > Devon, PA 19333 > > Direct: (610) 993-3299 > > Fax: (610) 650-5306 > > don.gu...@prufoxroach.com > > > > *From:* James Rankin [mailto:kz2...@googlemail.com] > *Sent:* Wednesday, August 26, 2009 7:47 AM > *To:* NT System Admin Issues > *Subject:* Re: DSQuery > > > > Have you tried adfind? > > http://www.joeware.net/freetools/tools/adfind/index.htm > > 2009/8/26 Clayton Doige <clayton.do...@gmail.com> > > Hi all, ust a quick one, I'd like to get information out of AD that tells > me which OU's contain computer accounts in a 2K3 domain. I can't seem to get > what i am looking for from DSQuery, so am just wondering if anyone out there > has done something non scripty that pulls this information out of AD? > > > > Thanks > > > > Clayton > > > > > > > > > -- > "On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into > the machine wrong figures, will the right answers come out?' I am not able > rightly to apprehend the kind of confusion of ideas that could provoke such > a question." > > http://raythestray.blogspot.com > > > > > > > > > > > > > > ------------------------------ > > *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. * > -- Regards, Clayton clay...@alsipius.com http://alsipius.com ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~