Office 365: Licenses (Built-in)

[Esben_D]

The report below gives back a list of Office 365 licenses.

The report will only list licenses when the following criteria are met:

• You have Lansweeper 7.1 or higher.
  
• There is Office 365 license data scanned.

Select Top 1000000 'license.png' As Icon,
  tblO365License.LicenseId,
  Case
    When tblO365Sku.DisplayName Is Null Then tblO365License.SkuPartNumber
    Else tblO365Sku.DisplayName
  End As DisplayName,
  tblO365License.SkuPartNumber,
  tblO365License.AppliesTo,
  tblO365License.ConsumedUnits As Consumed,
  tblO365License.PrepaidUnitsEnabled As Enabled,
  tblO365License.PrepaidUnitsSuspended As Suspended,
  tblO365License.PrepaidUnitsWarning As Warnings,
  tblO365Organization.DisplayName As Organization,
  tblO365Organization.TenantId
From tblO365License
  Left Outer Join tblO365Sku On tblO365Sku.Name = tblO365License.SkuPartNumber
  Inner Join tblO365Organization On tblO365License.OrganizationId =
    tblO365Organization.OrganizationId
Order By Organization