Get all user lisences from Office 365 to csv.

Hi,

Today I had to get a list from Office 365 with UserPrincipalName and MsolAccountSku. So here is the trick-script.

$ReportPath =
“c:userlist.csv”
Add-Content -value
(“UserPrincipalName”+”,”+”IsLicensed”+”,”+ “Licenses”)
-Path $ReportPath
$AllUsers =
Get-MsolUser -All
foreach ($User
in $AllUsers)
{
 $UserPrincipalName
= $User.UserPrincipalName
 $IsLicensed
= $User.IsLicensed
 $Licenses
= $User.Licenses.AccountSkuId
 Add-Content -value ($UserPrincipalName+”,”+$IsLicensed+”,”+$Licenses) -Path $ReportPath

}
Please note that copy/paste could possible break something 🙂
Cheers,
Author: Harri Jaakkonen

Leave a Reply

Your email address will not be published. Required fields are marked *