Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-05-2019 01:00 PM
The report below gives back a list of Office 365 users.
The report will only list users when the following criteria are met:
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
Labels:
- Labels:
-
Built-In Reports
-
Report Center
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-28-2019 04:59 PM
Good day!
If i needed to add a column to show which license each user was using, which field would I use?
Thanks!
If i needed to add a column to show which license each user was using, which field would I use?
Thanks!