→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

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