Get an overview of all Office 365 global administrators in your Office 365 environment. When scanning an Office 365 environment with Lansweeper, 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.
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
Explore Lansweeper for free.
No credit card required.