Join our NIS2 webinar & prepare for NIS2 compliance legislation – Save your seat 🍿

TRY NOW

Office 365 Users

Mailboxes 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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.