Exchange: Active Sync Devices (Built-in)

[Esben_D]

The report below gives back a list of Exchange active sync devices.

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

• You have Lansweeper 7.1 or higher.
  
• There is Exchange active sync device data scanned.

Select Top 1000000 'arrow_refresh.png' As Icon,
  Case
    When tblIntuneDevice.ManagedDeviceName Is Null Then
      tblExchangeActiveSyncDevice.DeviceFriendlyName
    Else tblIntuneDevice.ManagedDeviceName
  End As DeviceAssetName,
  tblIntuneDevice.AssetId As DeviceAssetId,
  tblExchangeActiveSyncDevice.DeviceModel,
  tblExchangeActiveSyncDevice.DeviceOs,
  tblExchangeActiveSyncDevice.ClientType,
  tblExchangeActiveSyncDevice.DeviceAccessState As AccessState,
  tblExchangeActiveSyncDevice.FirstSyncTime,
  tblExchangeActiveSyncDevice.LastSuccessSync,
  tblExchangeActiveSyncDevice.Mailbox,
  tblExchangeServer.AssetId As ServerAssetId,
  tblExchangeServer.Name As ExchangeServer
From tblExchangeActiveSyncDevice
  Inner Join tblExchangeServer On tblExchangeServer.ServerId =
    tblExchangeActiveSyncDevice.ServerId
  Left Outer Join tblIntuneDevice On tblIntuneDevice.Imei =
    tblExchangeActiveSyncDevice.DeviceImei
Order By tblExchangeActiveSyncDevice.DeviceFriendlyName