List all of your Office 365 mailboxes in one overview regardless of type. When scanning Office 365, Lansweeper retrieves a lot of data including mailbox data. This report provides an overview of some but not all of the mailbox information retrieved. Information such as username, display name, type of mailbox, alias and more is all displayed in the overview.
Office 365 Mailboxes Query
Select Top 1000000 'globe-green.png' As Icon,
tblO365Mailbox.DisplayName,
tblO365Mailbox.PrimaryEmail,
tblO365Mailbox.Alias,
tblO365Mailbox.RecipientType,
tblO365Mailbox.UserPrincipalName,
tblO365Mailbox.EmailAddresses,
tblO365Organization.DisplayName As Organization,
tblO365Organization.TenantId
From tblO365Mailbox
Inner Join tblO365Organization On tblO365Mailbox.OrganizationId =
tblO365Organization.OrganizationId
Order By tblO365Mailbox.DisplayName
