Report - count users per OU

[colweb]

Hi guys,

I've been asked to produce a fairly simple report - number of users per OU in the domain.

So I thought, as long as I can export the ADSI path with the user accounts into MSACCESS I can 'groupby' and get the count of user accounts.

However the ADSI path includes the DC name and User account, I know if I was advanced at VBA programming I could probably sort this out - but is there a better way to achieve this by tweaking Hyena first?

Thanks in advance.

[colweb]

Re: Report - count users per OU

Sorted this by accident -

First: =RIGHT(A1,LEN(A1)-FIND(",",A1)-1)

Not being an expert, looking at the above, its showing the "RIGHT" of the field, but the FIND command must work from the left = perfect as the first comma in the ADSI path is where I want to break the line.

cheers. still let me know if there's an easier way, but this will do me for now

[kstanush]

Re: Report - count users per OU

There is another AD field named 'canonicalname' that might help you. You probably have to manually add it to the query and it might help in sorting or grouping, and might not. Get more info here:
http://msdn2.microsoft.com/en-us/library/ms675436(VS.85).aspx