cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
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
0 REPLIES 0