How to Export Novell eDirectory Users to a CSV File

How to Export Novell eDirectory Users to a CSV File

Reference: 

How to configure Novell for Simple Binds

https://www.novell.com/support/kb/doc.php?id=7013279

CSVDE Reference

http://ss64.com/nt/csvde.html

csvde -f eDirExport.csv -s <ipOfServer> -r “(|(objectClass=organizationalUnit)(objectClass=inetOrgPerson))” -p Subtree -l “o,ou,objectClass,member,cn,dn,description,uid,givenName,sn,fullName,title,nspmDistributionPassword” -a "<DN of user>" "<password>"

Example:

csvde -f eDirExport.csv -s 10.5.0.206 -r “(|(objectClass=organizationalUnit)(objectClass=inetOrgPerson))” -p Subtree -l “o,ou,objectClass,member,cn,dn,description,uid,givenName,sn,fullName,title,nspmDistributionPassword” -a "cn=LdapUser,ou=SERVERS,o=UK" "mypassword"

DN of user is cn=LdapUser,ou=SERVERS,o=UK

This dumps a nice CSV file which can then be used to look at the nspmDistributionPassword field. If there is no entry in the field then it is not using a Universal Password and eDirectory did not sync the user over. 

Batch File
I ended up creating a batch file to perform this operation and then placing it on a scheduled task to dump the data at intervals. The first command is used to remove the previous version of the file, and the second command is used to dump the data.
nds_edirectory_users_export.bat