OU Membership

[Guest]

Is there a way to export the ou membership of user objects? I need to be able to export users in to excel and sort based on that information. Or is there a way to export the canonical format of an object? I know that would be easier to sort on.

[cmccullough]

Re: OU Membership

Add in either ADSI Path or DN and you should see what you are looking for. To add these to Hyena's view, go to File->Manage Object View->AD Queries.

[Guest]

Re: OU Membership

Yes, but the ADSI path shows the cn. I am looking for a way to show just the path to the ou or the canonical path for example:

Domain.com/OU1/OU2/UserObject

I need a way to sort the whole directory based on ou in excel.

[cmccullough]

Re: OU Membership

That's the only fields I know of that contain that data. One thought would be to create a comma-delimited output, because the paths have commas in them. When you open the file with Excel, it will split up that information. Delete the columns you don't need and you will be left with a column of OU=.

[kstanush]

Re: OU Membership

AD does have a 'constructed attribute' by the name of 'canonicalName' which you can add to any query by forcing in the attribute name (you can't pick it from the list as its not part of the AD schema). This will give you the path with the domain name first, then OU(s), and then finally the object name.