Exporting user lists by OU in Active Directory
Posted on 2011-03-08
Hi. I have a large global active directory (single domain) with thousands of users in hundreds of cities around the world. Each location is broken down into an OU, with a user being in a "Users" OU in a "City" OU, in a "Continent" OU, in a general location OU. So Joe in New York would be in LOCATIONS/NA/NY/USERS/Joe.
I need to find out how many users are in each city. I was trying to use CSVDE to export all the users to Excel, but I can not sort them by OU. Is there a way to do this, whether with CSVDE or some other utility?