Office 365: Users (Built-in)

[Esben_D]

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

[JTempleton]

Good day!

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

Thanks!