+ Post New Thread
Results 1 to 7 of 7
Wireless Networks Thread, Exporting data from the AD in Technical; Hi All, Is there any way to export data from the AD. I would like to export all staff members ...
  1. #1

    Join Date
    Dec 2005
    Posts
    453
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Exporting data from the AD

    Hi All,

    Is there any way to export data from the AD. I would like to export all staff members and their groups assigned to them.

    Any advice would much great



    Faza

  2. #2
    alan-d's Avatar
    Join Date
    Aug 2005
    Location
    Sutton Coldfield
    Posts
    2,414
    Thank Post
    360
    Thanked 256 Times in 187 Posts
    Rep Power
    75
    Action Dropdown menu -> Export

    Then choose the format you want it.

  3. #3

    Join Date
    Dec 2005
    Posts
    453
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I have only got Export List and that only exports the staff list. I unable to add the group as a column.

  4. #4

    mattx's Avatar
    Join Date
    Jan 2007
    Posts
    9,240
    Thank Post
    1,058
    Thanked 1,068 Times in 625 Posts
    Rep Power
    740
    You have to pay for this software but its well worth it:

    http://www.dovestones.com/

    Or you can use the CSVDE tool which Imports and exports data from Active Directory....

    http://technet2.microsoft.com/window....mspx?mfr=true

  5. #5
    alan-d's Avatar
    Join Date
    Aug 2005
    Location
    Sutton Coldfield
    Posts
    2,414
    Thank Post
    360
    Thanked 256 Times in 187 Posts
    Rep Power
    75
    Quote Originally Posted by faza View Post
    I have only got Export List and that only exports the staff list. I unable to add the group as a column.

    Sorry missed the groups bit

  6. #6

    Join Date
    Dec 2005
    Posts
    453
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Sorry i am a bit confused

  7. #7
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    34
    I've bodged this script together:

    Code:
    dsquery user "OU=Staff,DC=blah,DC=sch,DC=int" -limit 3 > userlist-output.txt
    for /f "tokens=*" %%i in (userlist-output.txt) do @echo ------ >> groups-output.txt && dsget user %%i -q -L -samid -display >> groups-output.txt && @echo ------ >> groups-output.txt && echo Groups: >> groups-output.txt && dsget user %%i -memberof -expand >> groups-output.txt && @echo ------ >> groups-output.txt
    findstr -iV "dsget" groups-output.txt > groups-output2.txt
    move /Y groups-output2.txt groups-output.txt
    notepad groups-output.txt
    "OU=Staff,DC=blah,DC=sch,DC=int" would have to be changed to the full path to your staff OU. I'm not sure if you need the adminpak installed on XP to have access to dsget and dsquery. 2003 should have them by default though.

    It will expand group memberships, so if they are a member of GTP-TRAINEES and that group is a member of TEACHERS it should list both. That means it can be slow to run, so get it working nicely then change the limit from 3 to 1000 and go make a brew.
    Last edited by sahmeepee; 8th February 2008 at 07:00 PM. Reason: tarted up output a little

SHARE:
+ Post New Thread

Similar Threads

  1. Exporting Timetables/Reports to the Web
    By Pumaedition in forum Windows
    Replies: 1
    Last Post: 30th November 2007, 10:33 AM
  2. Replies: 15
    Last Post: 9th October 2007, 07:49 PM
  3. Exporting Pupil Data From SIMS
    By David_Paylor in forum MIS Systems
    Replies: 9
    Last Post: 23rd March 2007, 03:16 PM
  4. Exporting emails, having problems.
    By richard in forum Windows
    Replies: 4
    Last Post: 1st December 2006, 05:07 PM
  5. Exporting or Searching Server Events
    By BKGarry in forum Windows
    Replies: 4
    Last Post: 26th September 2006, 10:06 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •