Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excerpt Include
AirWatch
AirWatch
nopaneltrue

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

Table Name

Description
dbo.DeviceOperatingSystemOS versions supported by AirWatch Console in current version
dbo.DeviceModelInfoDevice models (for Apple) or Android vendors supported by AirWatch Console in current version


User Management Tables

Table Name

Description

dbo.CoreUser


Admins – UserName, TimeZone, LastLogin, etc.

mobileManagement.EnrollmentUser


End users – UserName, LocationGroupID, DisplayName, UserPrincipleName, etc.


mobileManagement.CurrentDeviceEnrollmentUser


Ties enrolled devices to enrollment users


dbo.UserGroup


FriendlyName,DN,RootLocationGroupID, domain, etc

...

Table Name

Description

dbo.Certificate



Thumbprint, SubjectName, Validity Dates, etc.


dbo.LocationGroup


OG info – LocationGroupID, Name, CreatedOn, CreatedBy, MDMSettingsInheritable


deviceCommandQueue.DeviceQueue / deviceQueueAudit



Current commands queued / already executed commands for devices


dbo.SystemCode



All settings and default values configurable in the AirWatch Console - Groups & Settings


EventLog.EventLog


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.

Code Block
languagesql
themeEmacs
SELECT * FROM deviceCommandQueue.DeviceQueue WHERE commandid = 10;
DELETE * FROM deviceCommandQueue.DeviceQueue WHERE commandid = 10;