Author Posts

May 28, 2014 at 4:32 pm

Hi,

I have this command that gets all groups with "SiteAdmins" in the group name and selects its CN and Members:
Get-ADGroup -searchbase "DC=contoso,DC=com" -filter {name -like "*SiteAdmins*"} -Properties * |
Select-Object CanonicalName,Members | Format-Table -Wrap

However, on the "Members" column, I get the names on a distinguished name (DN) format:
(for example: {CN=Smith\, John,OU=Delegation,DC=contoso,DC=com}).

How do I get the "Members" column to show the display name instead (Smith, John)?

Thanks in advance!

May 28, 2014 at 4:35 pm

The Members property contains DNs; you'd need to take those and look up the user objects.

May 28, 2014 at 4:54 pm

It might work better to just pipe Get-ADGroup to Get-ADGroupMember:

Get-ADGroup -searchbase “DC=contoso,DC=com” -filter {name -like “*SiteAdmins*”} | Get-ADGroupMember | Select Name