Hi,

Hopefully someone can point me in the right direction. I'm trying to query AD for all users and the groups that user is a member of, and export the data to a CSV file.

I can export the users:

$FilePath = "output.csv"
$OuDomain = "DC=DOMAIN, DC=local"
Get-QADUser -searchRoot $OuDomain -SizeLimit 0 `
| select-Object dn, sAMAccountName ` | Export-Csv $FilePath

How would I add a get-qadmemberof to this? I tried placing it after the select-object but get an error.

Thanks.

I am not sure this is the exact format you want, and it will be difficult to get this readable in a CSV file, but try this...

Get-QADUser -searchRoot $OuDomain -SizeLimit 0 | Select-Object dn, sAMAccountName, @{Name="Groups";Expression={(Get-QADMemberOf $_ | Select-Object -expandProperty Name) -join ";"}} | export-csv $FilePath

This will concatenate all your group names separated by ";".

Thanks a lot Jonathan, pretty much exactly what I wanted. Much appreciated!