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