Office 365 introduced the new reporting powershell cmdlet Get-LicenseVsUsageSummaryReport to retrieve a summary report that identifies the number of active users across each installed software licenses (Exchange Online, SharePoint Online, Skype for Business Online, and Microsoft Yammer).
Deprecated – Get-LicenseVsUsageSummaryReport
This method is being deprecated as of January 29, 2018. You can refer to this post to generate license usage summary reports : Export Microsoft 365 License Usage Report using PowerShell.
The following command gets a summary report of the number of entitled users for the workload, the number of provisionally entitled (trial) users for the workload and the count of active licensed users.
Get-LicenseVsUsageSummaryReport
Export License Vs Usage Summary Report:
Use the below powershell command to export the license vs usage summary report to CSV file.
Get-LicenseVsUsageSummaryReport | Select Date,TenantGuid,Workload,NonTrialEntitlements,TrialEntitlements,ActiveUsers | Export-CSV "C:\LicenseVsUsageSummaryReport.csv" -NoTypeInformation -Encoding UTF8
Sample License Usage Report:
Advertisement
Get-LicenseVsUsageSummaryReport | Select Date,TenantGuid,Workload,NonTrialEntitlements,TrialEntitlements,ActiveUsers
This method is being deprecated as of January 29, 2018. See details, and information on replacement MS Graph APIs available at
https://techcommunity.microsoft.com/t5/Office-365-Blog/Announcing-the-General-Availability-of-Microsoft-Graph-reporting/ba-p/137838.
+ CategoryInfo : NotSpecified: (:) [], CFRV2ServiceDeprecatedException
+ FullyQualifiedErrorId : [Server=DM5PR18MB1580,RequestId=be11a667-918b-4acf-ae16-eeeaf0bbc4f7,TimeStamp=6/8/2022 8:12:01 PM] [FailureCategory=Cmdlet-CFRV2ServiceDeprecatedException] 3F714725
+ PSComputerName : outlook.office365.com