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 service plans.

The report will only list plans when the following criteria are met:
  • You have Lansweeper 7.1 or higher.
  • There is Office 365 data scanned.

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
0 REPLIES 0