Remove Licences in bulk from Office 365

[Max_Power]

I need to remove the current licences assigned to students in Office 365 for student advantage and replace them with new licences as we have changed our MS agreement and the old one is about to expire.

 

I can run individual lines in powershell to remove the licences but is there a way to do this in bulk if i have a csv of all users? Struggling to find any commands that works.

 

Command I'm running for individual licences is;

Set-MsolUserLicense -UserPrincipalName username@domain -RemoveLicenses "SCHOOLNAME:OFFICESUBSCRIPTION_STUDENT"

 

Thanks in advance

[jaminben]

I'm just quickly guessing but something like the below will feed from a .csv.

 

$users = Import-Csv C:\Powershell\Office_365\userlist.csv

foreach ($user in $users)
   {
       Set-MsolUserLicense -UserPrincipalName $user.UserPrincipalName -RemoveLicenses "SCHOOLNAME:OFFICESUBSCRIPTION_STUDENT"
   }

 

Where UserPrincipalName is the column header.

Edited November 2, 2016 by jaminben

[Davit2005]

Not tested but I use the similar script to assign license to users but I guess it could be reversed using the -RemoveLicenses command you have specified.

 

The idea being to get a list of licensed users and export to a file, hash the Return command once you are happy with the exported csv

 

Get-MsolUser -LicensedUsersOnly -All | Select UserPrincipalName,displayName | Export-Csv LicensedExport.csv -Notypeinformation

 

# Hash below line to remove the licenses

Return

 

# Import the CSV of Non-Licensed Users

$Licenserows = import-csv "LicenseExport.csv"

 

# Remove license User Beginning Loop

 

 

ForEach ($row in $Licenserows) {

 

$UnLicensedUPN = $row.UserPrincipalName

$UserName = $row.displayName

Set-MsolUserLicense -UserPrincipalName $UnLicensedUPN -RemoveLicenses "SCHOOLNAME:OFFICESUBSCRIPTION_STUDENT"

}

[Arthur]

I need to remove the current licences assigned to students in Office 365 for student advantage and replace them with new licences as we have changed our MS agreement and the old one is about to expire.

Unless I have misunderstood the question, surely you wouldn't need to remove and add the exact same license to students again? You would just add the new product key for the license in the admin portal?

[rickjames]

jaminben's example should do the trick

[NetworkNinja]

If you still need any help with this i might be able to. We have a code which we use to change all licenses for all users in office 365.

 

I would post on here but i can't seem to find the part where you can copy and paste code.

[darkest_star]

If you have quite a bit of licencing changes to do or just want an over view of licences then I find this utility works really well:

 

https://gallery.technet.microsoft.com/Office365-License-cfd9489c/view/Discussions

 

Its worked a treat for me to remove licence features for a large number of users.

[Max_Power]

Thank you - managed to get licences removed and new ones added using slightly amended versions of codes written above.

 

Ediy * downloading the utility and will give that a try as well.