Close

August 10, 2016

Create a Report to Find SharePoint Online Licensed Users

You can create a report on all SharePoint Online licensed users within your Office 365 tenant by following the example below:

Connect to Office 365 via PowerShell

Run the Commands Below in PowerShell ISE (Administrator Access)
The following commands will connect to your tenant, and then create a CSV report for you to filter on:

1
2
3
Import-Module MsOnline
Connect-MsolService
Get-MsolUser -All | where {$_.isLicensed -eq $true -and $_.Licenses[0].ServiceStatus[7].ProvisioningStatus -ne "Disabled"} | Export-Csv "./SPOnlineLicensedUsers.csv"

More info:

Leave a Reply

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