Get-ADGroup CN and Members

This topic contains 2 replies, has 3 voices, and was last updated by Profile photo of Matt McNabb Matt McNabb 2 years, 6 months ago.

  • Author
    Posts
  • #15713
    Profile photo of Norlan Solis
    Norlan Solis
    Participant

    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!

  • #15714
    Profile photo of Don Jones
    Don Jones
    Keymaster

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

  • #15715
    Profile photo of Matt McNabb
    Matt McNabb
    Participant

    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

You must be logged in to reply to this topic.