Announcement

Collapse
No announcement yet.

List all users of all groups in OU

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • List all users of all groups in OU

    Hello,
    I need to list all users in all groups in an OU.

    I have been asked to report on user permissions of a wiki-like site that uses AD permissions, and while I can get it to spit out a list of names, I can not get the data in a readable format also listing the groups.

    I would like something like
    OU
    -Group1
    -UserA
    -UserB
    -Group2
    -UserC
    -UserD

    The best I have come up with is to list all the groups in the OU, and pipe that though to list the Users, but that does not note what group the users are a member of.

    Thanks for any help,
    Wofen
    Good to be back....

  • #2
    Re: List all users of all groups in OU

    Powershell (with AD extensions loaded) will do it
    This script might do it:
    http://www.peetersonline.nl/2008/11/...th-powershell/

    (May need the Quest QAD cmdlets installed -- I haven't checked)
    Tom Jones
    MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
    PhD, MSc, FIAP, MIITT
    IT Trainer / Consultant
    Ossian Ltd
    Scotland

    ** Remember to give credit where credit is due and leave reputation points where appropriate **

    Comment


    • #3
      Re: List all users of all groups in OU

      Thanks Ossian,

      I just found something sad out, one of the environments that I have to complete this task in is 2003 without PS, and I am not allowed to install and PS add-ons...

      Anyone have a way to complete this with dsget? I have the following, but this just gives a stream of usernames, and not the group they are in.

      Dsquery Groups -"OU" | dsget -groups members

      Sorry for not mentioning this in the OP, but I only just found out about the 2k3 environment

      Wofen
      Last edited by Wofen; 5th September 2012, 01:05.
      Good to be back....

      Comment


      • #4
        Re: List all users of all groups in OU

        You don't need the QAD cmdlets -- there are the regular PowerShell AD tools which provide (slightly less efficient) functionality.

        Are you allowed to install Powershell on the 2003 box?

        DSQuery can be used recursively -- this link should do what you want
        http://www.experts-exchange.com/Data..._23804168.html
        (since its EE, you may need to access it via a search engine)
        Tom Jones
        MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
        PhD, MSc, FIAP, MIITT
        IT Trainer / Consultant
        Ossian Ltd
        Scotland

        ** Remember to give credit where credit is due and leave reputation points where appropriate **

        Comment


        • #5
          Re: List all users of all groups in OU

          Thanks for the push in the right direction. The page you linked did it the other way round of what I wanted (Listed Groups Users where in), but with some tweaking I was able to get it working.

          This page also explanes the process step by step if anyone is interested (Funny how you always find the pages after you come to the solution).

          http://retrohack.com/how-to-document...p-memberships/

          Thanks,
          Wofen
          Good to be back....

          Comment


          • #6
            Re: List all users of all groups in OU

            Glad you got it sorted -- and thanks for posting your solution back
            Tom Jones
            MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
            PhD, MSc, FIAP, MIITT
            IT Trainer / Consultant
            Ossian Ltd
            Scotland

            ** Remember to give credit where credit is due and leave reputation points where appropriate **

            Comment

            Working...
            X