AirWatch Mobile Devices

List All VMware AirWatch Mobile Devices

Aside from Intune, Lansweeper also scans Airwatch to retrieve detailed hardware, software and user information from mobile devices. You can also find typical mobile device information including the subscription carrier, enrollment date, the unique International Mobile Equipment Identity number, security patch level, operating system and more.

This overview report lists all VMware AirWatch devices alongside detailed information like the model, operating system, serial number and more. By clicking through to a device, you can easily get an overview of all of its detailed information.

AirWatch Mobile Devices Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblADusers.Username,
  tblADusers.Userdomain,
  tblADusers.Displayname,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAirWatchOrganizationGroup.Name As [Organization Group],
  tblAirWatchOrganizationGroup.AirWatchOrganizationGroupId,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAirWatchDevice.Platform,
  tsysAndroidOs.Name As [OS Name],
  tblAirWatchDevice.OsVersion As [OS Version],
  tblAirWatchDevice.SerialNumber,
  tblAirWatchDevice.LastEnrolledOn,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblAirWatchDevice On tblAirWatchDevice.AssetId = tblAssets.AssetID
  Left Join tblADusers On Lower(tblAirWatchDevice.UserEmailAddress) In
    (Lower(tblADusers.email), Lower(tblADusers.UPN))
  Left Join tsysAndroidOs On tblAirWatchDevice.OsVersion = tsysAndroidOs.Version
  Left Outer Join tblAirWatchOrganizationGroup On
    tblAirWatchOrganizationGroup.AirWatchOrganizationGroupId =
    tblAirWatchDevice.AirWatchOrganizationGroupId
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName