PowerShell - Get members of multiple groups

Hi, I'm trying to get the members of multiple groups listed is a CSV file. Here is an example of a script I've been trying to use to achieve the above: $csv = Import-Csv "C:\Temp\Groups\...

Windows PowerShell

LainRobertson

Aug 18, 2022

omc_st2022

Let me put some of the information you've provided together into a working example.

Here's our CSV file layout:

Here's our script for pulling the members:

(Import-Csv -Path "C:\Temp\Groups\testgroups.csv").GroupName |
    ForEach-Object { Get-AzureADGroup -Filter "displayName eq '$_'" } |
        ForEach-Object {
            $Group = $_;
            $Group | Get-AzureADGroupMember | Select-Object @{n="GroupName"; e = { $Group.DisplayName; }}, ObjectId, UserPrincipalName, DisplayName;
        }

And here's the results (using my own example group names):

Cheers,

Lain

LainRobertson

Silver Contributor

Aug 17, 2022

omc_st2022

Something's not lining up with the data held in the CSV and the Get-AzureADGroup command on line 4.

Essentially, line 4 is not producing any matching groups, which is the only way your $objectid variable can end up being $null.

Maybe the wrong names are in the CSV. Maybe there's no header or the header is not named GroupName - I have no idea as we can't see any data from your CSV file.

Anyhow, if you solve whatever the mismatch is, you'll solve the ObjectId is $null error.

Cheers,

Lain

omc_st2022

Copper Contributor

Aug 17, 2022

Thanks Lain, appreciate your input. I'm no PS expert, I've posted my CSV layout, hopefully I'm not doing something silly here. BTW my PS version is 5.1.19041.1682 if that helps. Cheers

Forum Discussion

PowerShell - Get members of multiple groups

Resources