Discover Office 365 Global Administrators

Discover Office 365 Global Administrators

Get an overview of all Office 365 global administrators in your Office 365 environment. When scanning an Office 365 environment with Lanswepeer, you can easily identify and list all of the global administrators. As part of access management, it is important to keep an eye on who has what type of access to applications in your environment including Office 365. Lansweeper will display the name, UPN, domain state department, email and more of each global administrator found.

Office 365 Global Administrators

Click to Open - Office 365 Global Administrators Query
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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting