‎03-05-2019 01:04 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now