VMware Workspace One UEM Mobile Devices
Mobile DevicesList All VMware Workspace One UEM (formerly AirWatch) Mobile Devices
Aside from Intune, Lansweeper also scans VMware Workspace One UEM 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 Workspace One UEM 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