Retrieve details such as their alias, recipient type, email address and which Exchange server they are on. When scanning an Exchange server, information about mailboxes, users, licenses, groups and active sync devices is all retrieved. This report shows basic information about mailboxes like alias, recipient type, email address.
Information such as which policies are applied, which quotas are in place, SCL settings, encryption settings, mailbox size and much more is also retrieved. This information can be easily added to this or a new custom report.
Exchange Mailboxes Query
Select Top 1000000 'globe-green.png' As Icon,
tblExchangeMailbox.DisplayName,
tblExchangeMailbox.Alias,
tblExchangeMailbox.RecipientType,
tblExchangeMailbox.RecipientTypeDetails,
addresses.email As EmailAddress,
tblExchangeServer.AssetId As ServerAssetId,
tblExchangeServer.Name As ExchangeServer
From tblExchangeMailbox
Left Outer Join (Select Min(tblExchangeMailboxAddress.Address) As email,
tblExchangeMailboxAddress.MailboxId
From tblExchangeMailboxAddress
Group By tblExchangeMailboxAddress.MailboxId) addresses On
addresses.MailboxId = tblExchangeMailbox.MailboxId
Inner Join tblExchangeServer On tblExchangeServer.ServerId =
tblExchangeMailbox.ServerId
Order By tblExchangeMailbox.DisplayName
