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
