Access DataMart exports as database tables in the AirWatch Database or in the CSV files in a network location. The AirWatch_DataMart_source database table contains the exports.

The following table highlights key table/.csv export results and associated columns within.

DB Table/CSV File Data Columns
ApplicationDevices Provides the identification number of devices, date, and time of any first-time enrollment.
  • ApplicationVersionKey
  • TenancyKey
  • LoadDate
  • LoadHour
  • DeviceID
  • FirstSeen
ApplicationDim Provides application name and identifier.
  • ApplicationKey
  • Identifier
  • Name
ApplicationFact Provides details about device applications such as authorized applications to use and the number of applications installed and uninstalled.
  • ApplicationVersionKey
  • TenancyKey
  • LocationGroupKey
  • CategoryKey
  • LoadDate
  • LoadHour
  • DeviceTypeKey
  • IsBlacklisted
  • IsPublished
  • InstalledDeviceCount
  • RemovedDeviceCount
  • AssignedCount
  • ApplicationTypeKey
ApplicationVersion Displays the version of applications listed in the database and available to the device end users.
  • ApplicationVersionKey
  • ApplicationKey
  • Version
ApplicationTypeDim Provides application type and name.
  • ApplicationTypeKey
  • ApplicationTypeName
CarrierDim Displays a list of carriers.
  • TenancyKey
  • CarrierKey
  • Carrier
DeviceDetails Displays device enrollment data and specifications of devices enrolled.

Examples include the serial number, the model, and the MAC address.
  • TenancyKey
  • LoadDate
  • LoadHour
  • DeviceID
  • Carrier
  • OSKey
  • CorpEmp
  • LocationGroupKey
  • Platform
  • DeviceName
  • EnrollmentUser
  • SerialNumber
  • DeviceIdentifier
  • DeviceModel
  • MACAddress
  • IMEI_ESN
  • PhoneNumber
  • LastSeen
DeviceDetails (cont.) Displays device enrollment data and specifications of devices enrolled.

Examples include the serial number, model, and MAC address.
  • DeployedProfileCount
  • IsMDMEnrolled
  • EnrollmentDate
  • AvailableSpace
  • TotalSpace
  • SpaceSampleTime
  • GPSLongitude
  • GPSLatitude
  • GPSSampleTime
  • WLANEnabled
  • VoiceRoamingEnabled
  • DataRoamingEnabled
  • IsRoaming
  • CellSampleTime
  • BatteryLifePercent
  • OnACPower
  • PowerSampleTIme
  • WLANSignalStrength
  • SignalStrengthSampleTime
  • TotalPhysicalMemory
  • AvailablePhysicalMemory
  • MemorySampleTime
  • BackupBatteryLifePercent
  • UserName
  • EnrollmentUserKey
  • AssetNumber
DeviceFact Provides device compliance status in addition to details about device activity.
  • OSKey
  • OwnershipKey
  • LocationGroupKey
  • TenancyKey
  • LoadHour
  • LoadDate
  • IsCompliant
  • IsCompromised
  • Active24hrs
  • Active30days
  • DeviceCount
DeviceTypeDim Provides device type and name.
  • DeviceTypeKey
  • PlatformName
LocationGroupDim Provides details about the location group.
  • LocationGroupKey

  • TenancyKey

  • LocationGroupID

  • Name

  • TypeName

  • DefCountryCode

  • DefCountryName

  • RegionCode

  • RegionName

  • Status

  • CustomerCode

    CultureCode

  • CultureName

  • CultureNativeName

  • EffectiveStartDate

  • EffectiveEndDate

LocationGroupFlat Displays details about the hierarchy, culture, language, and organization groups.
  • TenancyKey
  • ParentLocationGroupID
  • ChildLocationGroupID
  • ParentKey
  • ChildKey
  • LGlvl
OSDim Provides details about the OS
  • OSKey
  • OSMajorVersion
  • OSMinorVersion
  • OSBuildNumber
  • PlatformName
  • OSName
OwnershipDim Provides details about the device ownership type
  • PicklistItemID
  • Value
  • Text
  • SortOrder
  • LabelKey
  • Description
EnrollmentUserDim Provides details about the enrollment user.
  • TenancyKey
  • LocationGroupKey
  • EnrollmentUserKey
  • UserName
  • FirstName
  • MiddleName
  • LastName
  • EmailAddress
  • LastLoginDate
  • DeviceCount
AdministratorDim Provides details about the Administrator.
  • TenancyKey
  • LocationGroupKey
  • AdministratorKey
  • UserName
  • FirstName
  • MiddleName
  • LastName
  • EmailAddress
  • LastLoginDate
PolicyFact Provides the identification number of the devices and compliant status of the devices.
  • TenancyKey
  • LocationGroupKey
  • LoadDate
  • PolicyKey
  • DeviceID
  • Compliant
PolicyDim Provides details about the Policy.
  • TenancyKey
  • PolicyKey
  • PolicyName
  • PolicyDescription
  • Platform