Discover all Office 365 users in one overview. When scanning your Office 365 environment, Lansweeper will pull back a lot of information including users and their details. This report provides an overview of all your Office 365 users with their display name, UPN, username, user domain, department and more. User information is automatically linked to all previous user information detected from active directory or local user accounts. By navigating to specific users you can get more information about the user as well as the devices they use.
Office 365 Users Query
Select Top 1000000 'user.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
Order By tblO365User.DisplayName
