Use command to export AD LDAP address book

  Recently due to the epidemic,Some colleagues use Webmail instead of working from home,Therefore, you need to export the LDAP address book to a csv file,Remit to the mail system。Checked it online,Fortunately, this action is not difficult (I remember that the commands used in AD were very complicated before),Just use the built-in csvde command that specializes in processing csv.。


 ◎ For displayName、mail value object export。
 ◎ Export displayName、mail field (Attributes)。


csvde -r "(&(mail=*)(displayName=*)" -l displayName,mail -u -f adds.csv

# -r 針對屬性做篩選。
# -l 要匯出的欄位。
# -u 以 Unicode 格式匯出。
# -f 匯出成 csv 檔。


  After the actual export,There will be a small amount of unexpected data,Filter parameters can be added to the results。I, for one,Some of the data was originally set by me for separate use,I set the mail attribute of these objects to null or No-Mail-Group,Therefore, the following command can be used to exclude:

csvde -r "(&(mail=*)(displayName=*)(!mail=null)(!mail=No-Mail-Group))" -l displayName,mail -u -f adds.csv



This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments