Office 365: Domains (Built-in)

[Esben_D]

The report below gives back a list of Office 365 domains.

The report will only list domains when the following criteria are met:

• You have Lansweeper 7.1 or higher.
  
• There is Office 365 domain data scanned.

Select Top 1000000 'domain.gif' As Icon,
  tblO365Domain.DomainName,
  tblO365Organization.TenantId,
  tblO365Domain.AuthenticationType,
  tblO365Domain.IsAdminManaged,
  tblO365Domain.IsDefault,
  tblO365Domain.IsInitial,
  tblO365Domain.IsRoot,
  tblO365Domain.IsVerified,
  tblO365Domain.SupportedServices,
  tblO365Domain.State,
  tblO365Domain.AvailabilityStatus,
  tblO365Organization.DisplayName As Organization
From tblO365Domain
  Inner Join tblO365Organization On tblO365Organization.OrganizationId =
    tblO365Domain.OrganizationId
Order By tblO365Domain.DomainName