powershell script

Question

Hello

i have a powerscript below that produces the below,

Get-ADGroup -Filter 'GroupCategory -eq "Security"' -properties members | Select Name, @{name=”Users”;expression={$_.members -join “;”}} | export-csv -NoTypeInformation

im looking to get only the member names

"Class-name-Group","CN=Name 1,OU=Name of OU,OU=Name of OU OU=site,DC=site name,DC=site name,DC=site name;CN=name of user 2,OU=Name of OU,OU=Name of OU,OU=site name,DC=site name,DC=site name,DC=site;

Therefore is there a way using say -replace or -split to get as below, name of the group followed by just the names, even removing the CN=

"Class-name-Group","CN=Name 1;CN=name of user 2"

Many Thanks

Answer 1

Hi Mark,

If I get this right you want to have the Display Names of the group members? Is that correct? If so, why not just using it like that:

(Get-ADGroup -Filter 'GroupCategory -eq "Security"' -properties members | Get-ADGroupMember).name

Not quite sure what your exact goal is, so a bit more information would help.

Thnaks and Regards,
Stoyan

Answer 2

Hi Yes would like the Group name and then the group members, with my current script it is listing the full path of the members (having there CN=, and OU =

I would so it does not cn= and Ou=
Hope that makes more sense
thanks

Answer 3

Thanks, However as per you output for the GroupMembers i only want it to say the name like Joe Bloggs is in the Administator group. as per your example its showing the full path to where the object is.

Does that make sense?

Answer 4

i posted the same question on another forum and somethere has given me the answer

Get-ADGroup -Filter 'GroupCategory -eq "Security"' -properties members |
Select Name, @{name=”Users”;expression={ ($_.members -ireplace 'CN=(?<User>[^,]).','${User}' )-join “;”}} |
export-csv -NoTypeInformation

Many Thank you for your help

Answer 5

Hi,

Thank you for sharing the solution. Please "Accept Answer" to help other community members find the helpful reply quickly.

Best Regards,
Ian