cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
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
0 REPLIES 0