SS64 Forum

Loibl

New Member

Registered: 05 Aug 2015

Posts: 1

Get user user details with dsquery and dsget

Hello,

i have the following problem:

I want to export the phone number, the email address etc. of all users from AD and create a CSV-file with it.
But if I type "dsquery user -samid * -limit 10000 | dsget user -email -fn -ln -tel -mobile -fax -dept | find "+">C:\adexport.csv" the output isn´t formatted and there is no unicode.
So everything like ü, ä etc. is displayed incorrect.
I tried csvde already but I don´t really get the syntax.
Could anyone help me, please?

Simon Sheppard

Admin

Registered: 27 Aug 2005

Posts: 1,130

Website

Re: Get user user details with dsquery and dsget

If you need unicode support your best option is to use PowerShell, theres a whole raft of AD cmdlets which can do this.