Exchange: Mailboxes (Built-in)

[Esben_D]

The report below gives back a list of Exchange mailboxes.

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

• You have Lansweeper 7.1 or higher.
  
• There is Exchange mailbox data scanned.

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