Office 365 Users

List All Users Office 365 Users

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

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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting