Hello, I need help to extract some data from AD. I have no problem extracting data from the default AD fields. I have difficulty extracting Exchange data stored in custom attributes. The data i need is stored in extensionAttribute1. How do i get this and export to csv.?

Exchange 2003

Using Powershell, and the Quest AD cmdlets: get-qaduser <useraname> -includeallproperties | select displayname,extenionattribute*[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

Sorry, I noticed you only want extensionattribute1, so: get-qaduser -sizelimit 0 -includedproperties extensionattribute1 | select displayname,extensionattribute1 | export-csv ext_att1.csv -notype [string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

Hi mjolinor, This looks good so far. What I actually need are these : firstname, last name, phone(business 1), email, extensionattribute1 So how will the powershell script look like now? Thank you very much for your patience

The rest of the properties are already included in the default property set, so: get-qaduser -sizelimit 0 -includedproperties extensionattribute1 | select firstname,lastname,phonenumber,email,extensionattribute1 | export-csv ext_att1.csv -notype[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

You have been most helpful...i guess it's time for me to learn some powershell. Any thoughts on where to begin?

This is the original (V1) documentation pack. It's available for download for easy offline reading. It's a good basic primer in Powershell. http://www.microsoft.com/downloads/details.aspx?familyid=B4720B00-9A66-430F-BD56-EC48BFCA154F&displaylang=en [string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

Once again, thank you