Hey guys,

I have a script that searches Exchange for a list of mailboxes, then uses mailboxdisplayname in GET-QADUSER where I include publicdelegates and publicdelegatesbl attribs.

I now want to export the user, the users who are delegates and, those who the user is a delegate of to csv.

Any ideas ?

Exchange 2003
AD 2003
Powershell v1.0
Quest AD cmdlets


Thanks in advance.

OK - must be a tough question - no replies :(

Well...
1. This is AD not Exchange forum, so folks who play with exchange may simply ignore this sub-forum. ;)
2. You are not very specific about outcome you expect. I can see two possible:
Repeat other values and add multivalued to each clone:
Param1,Param2,Param3,Param4-Value1
Param1,Param2,Param3,Param4-Value2
....
Put multi-valued in one 'cell', but formated in a proper (for use case) format
Param1,Param2,Param3,Param4-Value1;Param4-Valu2;...

Try this

$users = Get-QADUser -SizeLimit 0 -IncludedProperties publicdelegates,publicdelegatesbl -LdapFilter '(publicdelegates=*)(publicdelegatesbl=*)'

$users | select * | foreach {
$publicdelegates = $_.publicdelegates | get-qaduser | foreach {$_.name}
$_.publicdelegates = [string]::join(';',$publicdelegates)

$publicdelegatesbl = $_.publicdelegatesbl | get-qaduser | foreach {$_.name}
$_.publicdelegatesbl = [string]::join(';',$publicdelegatesbl)

$_
} | Select-Object Name,DN,publicdelegates,publicdelegatesbl

Shay - I have your code above working but am trying to get email addresses associated with publicdelegates and publicdelegatesbl attribs as well as trying to get it all out into a .csv file. Can you help me?

We have over a 1000 users with publicdelegates set and as you might expect we see a fair amount of help desk tickets related to delegate issues.