Help with Powershell Script

[Enixus86]

Hi

I am new to powershell and I have to create a script to do the following :

I need to get a list of AD groups and extract the users in a CSV file. I can do that fine but I don’t know how to divide the users by AD groups in the CSV file.

I have the below script but all the users are listed together :

PowerShell

foreach ($line in import-csv \\Path\ListofADgroups.csv){Get-ADGroupMember -Identity $line.Name -Recursive | Get-ADUser -Property DisplayName | Select Name,ObjectClass,DisplayName | Export-Csv -Path C:\temp\Users.csv | -NoTypeInformation -append}

1	foreach ($line in import-csv \\Path\ListofADgroups.csv){Get-ADGroupMember -Identity $line.Name -Recursive | Get-ADUser -Property DisplayName | Select Name,ObjectClass,DisplayName | Export-Csv -Path C:\temp\Users.csv | -NoTypeInformation -append}

In the ListofADgroups.csv file there is a long list of AD groups. I am trying to list the users by AD group in the CSV file.

 

Any help would appreciated.

Thank you so much

A noob

Enrica

• This topic was modified 9 months ago by Enixus86.
• This topic was modified 8 months, 3 weeks ago by Enixus86.

[Doug Maurer Participant Topics: 9 Replies: 707 Points: 2,847Rank: Community Hero]

Enrica, welcome to Powershell.org. Please take a moment and read the very first post on top of the list of this forum: Read Me Before Posting! You’ll be Glad You Did!.

When you post code or error messages or sample data or console output format it as code, please.
In the “Text” view you can use the code tags “PRE“, in the “Visual” view you can use the format template “Preformatted“. You can go back edit your post and fix the formatting – you don’t have to create a new one.
Thanks in advance.

If I understood you correctly, I think this will do it.

PowerShell

foreach ($line in import-csv \\Path\ListofADgroups.csv){ Get-ADGroupMember -Identity $line.Name -Recursive | foreach { get-aduser $_ -Property displayname | Select Name,ObjectClass,DisplayName | Select @{N='ADGroup';e={$line.Name}}, @{N='DisplayName';e={$_.displayname}}, @{N='UserName';e={$_.name}}, @{N='ObjectClass';e={$_.Objectclass}} } | Export-Csv -Path C:\temp\Users.csv -NoTypeInformation -append }

1 2 3 4 5 6 7 8 9

foreach ($line in import-csv \\Path\ListofADgroups.csv){     Get-ADGroupMember -Identity $line.Name -Recursive | foreach {         get-aduser $_ -Property displayname | Select Name,ObjectClass,DisplayName |             Select @{N='ADGroup';e={$line.Name}},                    @{N='DisplayName';e={$_.displayname}},                    @{N='UserName';e={$_.name}},                    @{N='ObjectClass';e={$_.Objectclass}}     } | Export-Csv -Path C:\temp\Users.csv -NoTypeInformation -append }

[Enixus86 Participant Topics: 1 Replies: 1 Points: -6Rank: Member]

Thank you very much, that is exactly what I needed. I have also fixed the formatting of my post 🙂

 

[Doug Maurer Participant Topics: 9 Replies: 707 Points: 2,847Rank: Community Hero]

Win and win! I’m glad to help. Take care.

[Author]

Posts