CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

Exchange Active Sync Devices

Exchange

Find Exchange Active Sync Devices in Your Network

List all your Exchange active sync devices along with information about the device model, operating system, sync time and more. Active sync devices allow you to sync data from your Exchange server with mobile devices. When scanning an Exchange server, Lansweeper will also retrieve any active sync devices with details about the model, operating system, state, sync time and more. Get an overview of which mobile dives are already linked to your Exchange server and which ones are still missing. Exchange Active Sync Devices

Exchange Active Sync Devices Query

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.