Exchange: Users (Built-in)

[Esben_D]

The report below gives back a list of Exchange users.

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

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

Select Top 1000000 'user.png' As Icon,
  Case
    When tblExchangeUser.DisplayName Is Null Or
      tblExchangeUser.DisplayName = '' Then tblExchangeUser.Name
    Else tblExchangeUser.DisplayName
  End As DisplayName,
  tblExchangeUser.UserPrincipalName,
  tblADusers.Username,
  tblADusers.Userdomain,
  Case
    When tblExchangeUser.AccountDisabled = 1 Then Convert(bit,0)
    Else Convert(bit,1)
  End As Enabled,
  tblExchangeServer.AssetId As ServerAssetId,
  tblExchangeServer.Name As ExchangeServer
From tblExchangeUser
  Left Outer Join tblADusers On
    tblADusers.UPN = tblExchangeUser.UserPrincipalName
  Inner Join tblExchangeServer On tblExchangeServer.ServerId =
    tblExchangeUser.ServerId
Order By DisplayName