exporting Distribution group members from AD

cahmadhcahmadh Posts: 15Member ■□□□□□□□□□
How we can export the distribution group members in word or excel format from the active directory in windows 2003 server environment?

I have a distribution group name x and it is in "users" OU. The company domain name is mycompany.com.au

i try to google it and applied some solutions but none of those worked?

Any idea?

BR, Ahmad

Comments

  • kalebkspkalebksp Posts: 1,033Member
    I'd use PowerShell with the Quest Cmdlets. The command would be something line this:

    get-qadgroup groupname | get-qadgroupmember | export-csv C:\path\file.csv

    You could also omit the export-csv and just pipe it into a text file.
    Contradictions do not exist. Whenever you think you are facing a contradiction, check your premises. You will find that one of them is wrong.
    -Ayn Rand

    vCabbage
  • cahmadhcahmadh Posts: 15Member ■□□□□□□□□□
    I am trying to get this using the LDIFDE command but its no working.

    I want to avoid any installation on my server.



  • undomielundomiel Posts: 2,818Member
    dsquery group -name "x" | dsget group -members > C:\groupmembers.txt
    Jumping on the IT blogging band wagon -- http://www.jefferyland.com/
  • cahmadhcahmadh Posts: 15Member ■□□□□□□□□□
    Thank you undomiel, could you please let me know how i can get the email address of the members of that particular OU.
  • undomielundomiel Posts: 2,818Member
    dsquery group -name "x" | dsget group -members | dsget user -email > C:\groupmembersemail.txt

    Take a look at dsget user /? for more options of what info you can get.
    Jumping on the IT blogging band wagon -- http://www.jefferyland.com/
  • cahmadhcahmadh Posts: 15Member ■□□□□□□□□□
    undomeil, dear you are diamond :D

    Its done.
  • Sathishkumar.v87Sathishkumar.v87 Posts: 1Registered Users ■□□□□□□□□□
    export the active ad group members in windows 2003 server, I have a cmd to export the group member user, But dont have idea about applying filters here is the one i use to export group member without filter

    dsquery group -name "groupname" | dsget group -members > C:\filename.csv
Sign In or Register to comment.