‎03-05-2019 01:02 PM
Select Top 1000000 'license.png' As Icon,
Case
When tblO365Sku.DisplayName Is Null Then tblO365ServicePlan.ServicePlanName
Else tblO365Sku.DisplayName
End As DisplayName,
tblO365ServicePlan.ServicePlanName,
tblO365ServicePlan.ProvisioningStatus,
tblO365ServicePlan.AppliesTo,
Case
When tblO365Sku_2.DisplayName Is Null Then tblO365License.SkuPartNumber
Else tblO365Sku_2.DisplayName
End As [License DisplayName],
tblO365Organization.DisplayName As Organization,
tblO365Organization.TenantId
From tblO365ServicePlan
Left Outer Join tblO365Sku On
tblO365Sku.Name = tblO365ServicePlan.ServicePlanName
Inner Join tblO365License On tblO365License.LicenseId =
tblO365ServicePlan.LicenseId
Inner Join tblO365Organization On tblO365License.OrganizationId =
tblO365Organization.OrganizationId
Left Outer Join tblO365Sku As tblO365Sku_2 On tblO365Sku_2.Name =
tblO365License.SkuPartNumber
Order By Organization
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now