No announcement yet.

Report - count users per OU

  • Filter
  • Time
  • Show
Clear All
new posts

  • Report - count users per OU

    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.

  • #2
    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


    • #3
      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:
      Kevin Stanush
      SystemTools Software Inc.