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 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
0 REPLIES 0