Office 365: Organizations (Built-in)

[Esben_D]

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

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

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

Select Top 1000000 'office365_16.png' As Icon,
  tblO365Organization.DisplayName As Organization,
  tblO365Organization.TenantId,
  tblO365Organization.Country,
  tblO365Organization.CountryName,
  tblO365Organization.State,
  tblO365Organization.City,
  tblO365Organization.Street,
  tblO365Organization.PostalCode,
  tblO365Organization.TelephoneNumber,
  tblO365Organization.DirSyncEnabled,
  tblO365Organization.CompanyLastDirSyncTime,
  tblO365Organization.LastScan
From tblO365Organization
Order By Organization