Office 365: Service Plans (Built-in)

[Esben_D]

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