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,
  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

Show

Hide