Get-AD GroupMember from a list of users in a csv

Question

I have a list of users in a csv file, they are the displaynames. I wrote the following but all I get back is the displayname not the memberships what is needed?

$csv = Import-CSV "c:\users.csv"
foreach($user in $csv){ 
$Displayname = $user.displayname
Get-aduser -filter {displayname -eq $displayname} -Properties displayname,memberOf |`
select "Displayname","MemberOf" | Export-Csv "c:\temp\usersmembership.csv"
}

not sure if it matters but I get the exepcted result by doing the exact same thing but without the double quotes in the 'select' statement — Matt, Jul 12 '17 at 23:03

score 0 · Answer 1 · edited Jul 13 '17 at 13:12

The MemberOf field is an object of type Microsoft.ActiveDirectory.Management.ADPropertyValueCollection that will not dump to CSV. You need to use a select statement that will calculate the contents of the feild as text. This line will get the contents (Which will be annoying distinguished names), look up the common names, convert the output to text, and replace newlines with commas.

Get-ADUser -filter {displayname -eq $displayname} -prop displayname,memberof `
  | select DisplayName,@{Name='Groups';Expression={$_ | Select -ExpandProperty MemberOf `
  | Get-ADGroup | select -ExpandProperty Name | Out-String | %{$_ -replace ("`n",",")}}} `
  | Export-Csv "c:\temp\usersmembership.csv"

Thanks for this very useful information, I was not aware this was happening. This works thank you — Jedi Administrator, Jul 13 '17 at 15:07

Get-AD GroupMember from a list of users in a csv

1 Answers1