‎03-05-2019 01:05 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now