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