Exchange Users

Find All Exchange Users in Your Network

List all your Exchange users along with information such as their user principal name, status, Exchange server and more. When scanning an Exchange server, information about mailboxes, users, licenses, groups and active sync devices is all retrieved. This report will list all users along with basic information and which Exchange server they are on. You can also add additional user information to the report be editing the report. Additional users, mailbox and Exchange options can all be added.

Exchange Users Query

Select Top 1000000 'user.png' As Icon,
    When tblExchangeUser.DisplayName Is Null Or
      tblExchangeUser.DisplayName = '' Then tblExchangeUser.Name
    Else tblExchangeUser.DisplayName
  End As DisplayName,
    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 =
Order By DisplayName

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting