De-dupe is usually trivial to do in a database (aka Access). Cheers Ken
From: Clayton Doige [mailto:[email protected]] Sent: Wednesday, 26 August 2009 10:59 PM To: NT System Admin Issues Subject: Re: DSQuery 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 <[email protected]<mailto:[email protected]>> 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: [email protected]<mailto:[email protected]> Phone: 610-807-6459 Fax: 610-807-6003 ________________________________ From: Don Guyer [mailto:[email protected]<mailto:[email protected]>] 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 [email protected]<mailto:[email protected]> From: James Rankin [mailto:[email protected]<mailto:[email protected]>] 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 <[email protected]<mailto:[email protected]>> 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? ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
