Office 365: User Mailboxes (Built-in)

[Esben_D]

The report below gives back a list of Office 365 users mailboxes.

The report will only list mailboxes when the following criteria are met:

• You have Lansweeper 7.1 or higher.
  
• There is Office 365 user mailbox data scanned.

Select Top 1000000 'globe-green.png' As Icon,
  tblO365Mailbox.DisplayName,
  tblO365Mailbox.PrimaryEmail,
  tblO365Mailbox.Alias,
  tblO365Mailbox.RecipientType,
  tblO365Mailbox.RecipientTypeDetails,
  tblO365Mailbox.UserPrincipalName,
  tblO365Mailbox.EmailAddresses,
  tblO365Organization.DisplayName As Organization,
  tblO365Organization.TenantId
From tblO365Mailbox
  Inner Join tblO365Organization On tblO365Mailbox.OrganizationId =
    tblO365Organization.OrganizationId
Where tblO365Mailbox.RecipientTypeDetails = 'UserMailbox'
Order By tblO365Mailbox.DisplayName