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
