cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Office 365: Users (Built-in)

Esben_D
Lansweeper Employee
Lansweeper Employee
The report below gives back a list of Office 365 users.

The report will only list users when the following criteria are met:
  • You have Lansweeper 7.1 or higher.
  • There is Office 365 user data scanned.

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

JTempleton
Engaged Sweeper III
Good day!

If i needed to add a column to show which license each user was using, which field would I use?

Thanks!