Each application uploaded to AirWatch would have its own row in the deviceApplication.Application table. Each column contains specific attributes for that object. For example, an application in the deviceApplication.Application table would have a column for Name, PackageID, LocationGroup, etc.
Device Management Tables
|dbo.DeviceOperatingSystem||OS versions supported by AirWatch Console in current version|
|dbo.DeviceModelInfo||Device models (for Apple) or Android vendors supported by AirWatch Console in current version|
User Management Tables
Admins – UserName, TimeZone, LastLogin, etc.
End users – UserName, LocationGroupID, DisplayName, UserPrincipleName, etc.
Ties enrolled devices to enrollment users
FriendlyName,DN,RootLocationGroupID, domain, etc
Thumbprint, SubjectName, Validity Dates, etc.
OG info – LocationGroupID, Name, CreatedOn, CreatedBy, MDMSettingsInheritable
deviceCommandQueue.DeviceQueue / deviceQueueAudit
Current commands queued / already executed commands for devices
All settings and default values configurable in the AirWatch Console - Groups & Settings
Where console Event Logs pull from
Example of deleting "wipe device" commands from Message Queue
This is needed in case of accidental mass wipe created as result of incorrect compliance policy etc.
SELECT * FROM deviceCommandQueue.DeviceQueue WHERE commandid = 10; DELETE * FROM deviceCommandQueue.DeviceQueue WHERE commandid = 10;