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