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