Script for Quest Powershell in order to pull data from AD

Remove the -ObjectAttributes option so it's like this:

Get-QADUser t70869 | select samAccountName, givenName, sn, displayName, description, mail,proxyaddresses,canonicalname, dn,extensionAttribute1,extensionAttribute5,extensionAttribute9,extensionAttribute14, extensionAttribute15 | export-csv C:\Users\t70869\Documents\Temp\test3.csv

Thank you Daniel..

I did not got the results for below attributes..

ProxyAddresses= System.String[]
extensionAttribute1= Blank
extensionAttribute5= Blank
extensionAttribute9= Blank
extensionAttribute14= Blank
extensionAttribute15= Blank

Thanks& Regards
Samiyuddin Mohammed

You may have to specify the -includedproperties parameter with your Get-QAD user command and listing these so:

Get-QADUser t70869 -includedproperties extensionAttribute1,extensionAttribute5,extensionAttribute9,extensionAttribute14,extensionAttribute15

...and then the rest of the code as written.

I'm able to extract extensionAttribute's

But, i'm getting ProxyAddresses=System.String[]

Get-QADUser t70869 -includedproperties extensionAttribute1,extensionAttribute5,extensionAttribute9,extensionAttribute14,extensionAttribute15| select samAccountName, givenName, sn, displayName, description, mail,proxyaddresses,canonicalname, dn,extensionAttribute1,extensionAttribute5,extensionAttribute9,extensionAttribute14, extensionAttribute15 | export-csv C:\Users\t70869\Documents\Temp\test03.csv

Yup, proxy addresses aree a bit trickier to deal with as you need to take that system string and convert it to a regular string.

The line starting with $_.proxyaddresses is where that attribute gets fixed for your output.

This is a clumsy solution but I think it will get you what you want:

(If you don't like the '##' between the proxy addresses, just change it to something else)

Get-QADUser t70869 -includedproperties extensionAttribute1,extensionAttribute5,extensionAttribute9,extensionAttribute14,extensionAttribute15 | %{

$_.proxyaddresses | %{ $Addr = $_ + "##"; $AddrList = $AddrList + $Addr}

$_ | Add-Member -MemberType NoteProperty -Name ProxyAddressString -Value $AddrList

$_ | select samAccountName, givenName, sn, displayName, description, mail,proxyaddressString,canonicalname, dn,extensionAttribute1,extensionAttribute5,extensionAttribute9,extensionAttribute14, extensionAttribute15 | export-csv C:\Users\t70869\Documents\Temp\test03.csv -NoTypeInformation -Append

}

Thanks Johnny..

It was throwing me error when i ran above script along with " -Append"

So, i removed "-Append" and ran the script, it was successfully completed. But, i see duplicate entry's in ProxyAddressString column. looks like all my ProxyAddresses repeated 5 times..