Exporting Active Directory user info to CSV
Active Directory User Profiles, CSV, Security in 2010, Windows, Windows Server 2008 R2, Windows Server Security, Windows Server User Profiles
Can we export all of our AD data
to a CSV file for backup purposes? Can we export the passwords as well? Will
they be encrypted? Where can we find the
encryption key so we can make heads or tales of them.
Software/Hardware used:
Windows server 2008 r2
Software/Hardware used:
Windows server 2008 r2
ASKED:
September 24, 2010 4:15 PM
UPDATED:
September 28, 2010 11:27 PM
Answer Wiki:
This can be perceived as a hacking question. There is no way to export the actual passwords from AD. All you can get from AD are the password hashes and that will have to be done directly on a domain controller. You can use dsquery or the excellent PowerGUI utility to get a list of AD users.
To see all answers submitted to the Answer Wiki: View Answer History.
The tool best suited for your requirement is likely csvde:
http://technet.microsoft.com/en-us/library/cc732101(WS.10).aspx
As the previous answer suggests, exporting password hashes is possible, running as an Administrator, but this is not a reliable way to backup your AD database. For backup, you should use the native Windows Backup utility.