Office 365: Global Administrators (Built-in)

[Esben_D]

The report below gives back a list of Office 365 global administrators.

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

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

Select Top 1000000 'administrator.png' As Icon,
  tblO365User.DisplayName,
  tblO365User.UserPrincipalName,
  tblADusers.Username,
  tblADusers.Userdomain,
  tblO365User.AccountEnabled As Enabled,
  tblO365User.Department,
  tblO365User.Mail,
  tblO365User.ResetPasswordOnNextLogon,
  tblO365Organization.DisplayName As Organization,
  tblO365Organization.TenantId
From tblO365User
  Inner Join tblO365Organization On tblO365User.OrganizationId =
    tblO365Organization.OrganizationId
  Left Outer Join tblADusers On tblADusers.UPN = tblO365User.UserPrincipalName
Where tblO365User.IsGlobalAdministrator = 1
Order By tblO365User.DisplayName