Script to loop through a CSV file and to exit loop once all users have been licensed in M365

Question

Hi all,

I have an input CSV file like this:

UserPrincipalName

user1@test.com

user2@test.com

When I license these users in M365, it can take a couple of moments for the Get-MSolUser "IsLicensed" attribute to be set to "True".

I would like to have a PowerShell script so that when it is run, it will check to see when the users have been licensed. The script requirements would be:

Read the contents of the CSV file.
Create a loop so that the script will check if each user is licensed i.e. "Get-MsolUser -UserPrincipalName user1@test.com | select IsLicensed" and the "IsLicensed" value is equal to True
Once all users in the CSV file have been confirmed that they have been licensed, exit the loop.

What I have right now, is a foreach iteration which will read in my input file and check if the MSOLusers are licensed or not i.e.

$LicensedUsers = Import-Csv D:\Users.csv | Select UserPrincipalName

foreach ($user in $LicensedUsers)

{

*Get-MsolUser -UserPrincipalName $User.UserPrincipalName | select isLicensed*

}

The above will return the isLicensed value for each user in the CSV. I think I need a "wrapper" loop to check on the status of the Get-MsolUser -UserPrincipalName $User.UserPrincipalName | select isLicensed command and to keep looping until all users in the CSV file are licensed, but don't know how to incorporate the while loop part!

Thanks in advance!

Answer

HI,

Can you try this suggestion and check if achieve your need?

Will keep checking the license status of the users until all users are licensed.

If there are still unlicensed users after each check, it will wait for 60 seconds before checking again.

# If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

$LicensedUsers = Import-Csv D:\Users.csv | Select UserPrincipalName

# Initialize a variable to keep track of unlicensed users
$unlicensedUsers = $LicensedUsers

# While there are unlicensed users, keep checking their license status
while ($unlicensedUsers) {
    # Create a new array to hold any users that are still unlicensed
    $stillUnlicensed = @()

    foreach ($user in $unlicensedUsers) {
        $licenseStatus = Get-MsolUser -UserPrincipalName $user.UserPrincipalName | select -ExpandProperty isLicensed

        # If the user is not licensed, add them to the still unlicensed array
        if ($licenseStatus -eq $false) {
            $stillUnlicensed += $user
        }
    }

    # Replace the unlicensed users array with the still unlicensed array
    $unlicensedUsers = $stillUnlicensed

    # If there are still unlicensed users, wait for a while before checking again
    if ($unlicensedUsers) {
        Start-Sleep -Seconds 60
    }
}

Share via

Script to loop through a CSV file and to exit loop once all users have been licensed in M365

1 answer

Your answer