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 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