‎03-05-2019 01:01 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now