| agentprofile_id |
INT |
Applied agent profile ID, reference to AMDM_DEVICEAGENTPROFILE.devagentprofile_id table |
| agentversion |
VARCHAR (32) |
Installed Agent Version |
| alertstatusdeviceabsent* |
BIT |
Extended Device Absence Flag |
| androidforworkmode_id |
INT |
Pairing mode identifier in Android for Work, reference to AMDM_DEVICEAFWMODE.afwmode_id table |
| androidforworktokenset* |
BIT |
Flag that determines if the Android for Work token was successfully set |
| androidfwprofileready |
BIT |
Flag that determines if your Android for Work profile is ready |
| apnsapppushtoken |
NVARCHAR (256) |
Agent Push Token for iOS Platform |
| apnsmdmpushtoken |
NVARCHAR (256) |
Push token for iOS-owned MDM |
| appisenrolled |
BIT |
Flag that determines if the agent is installed and linked for iOS and Windows |
| badge |
INT |
Initial identifier for iOS platform |
| calendar_id |
INT |
Calendar ID associated with the device, reference to AMDM_CALEDNAR.cal_id table |
| cicmdb |
INT |
Identifier in CMDB, if connection is configured |
| companyowned* |
BIT |
Flag indicating whether the device is owned by the company |
| compromisedsecuritydevice |
VARCHAR (16) |
Description of the type of security breach (Rooted, JailBroken) |
| currentnetworkcarrier |
NVARCHAR (128) |
Current network operator of the device |
| devicehardware_id |
INT |
Hardware Information Record ID, reference to AMDM_DEVICEHARDWARE.devh_id table |
| devicenetwork_id |
INT |
Network information record ID, reference to AMDM_DEVICENETWORK.devn_id table |
| devicetype |
NVARCHAR (64) |
Device Type (SmartPhone, Tablet, PC) |
| enrollmentdate |
DATETIME |
Date of last linkage |
| enrollmentrecord_id |
INT |
Link record ID, reference to AMDM_PENDINGENROLL.penr_id table |
| expenseplan_id |
INT |
Applied consumption plan ID, reference to AMDM_EXPENSEPLAN.plan_id table |
| fulfilledpolicy |
BIT |
Assigned Policy Compliance Flag |
| gcmregistrationid |
NVARCHAR (2048) |
Token for push on Android platform |
| guid |
VARCHAR (50) |
Initial identifier for linking |
| healthdevicestartdate |
DATETIME |
Device Health Monitoring Start Date |
| id* |
INT |
Unique device identifier |
| imei |
NVARCHAR (128) |
Imei of the active slot at the time of linking |
| isknox* |
BIT |
Flag indicating whether the device supports Samsung Knox |
| issecuritybroken |
BIT |
Flag indicating if device security has been violated |
| istotallocked* |
BIT |
Flag indicating total block on Windows device |
| lastappliedexpense |
DATETIME |
Date of application of the consumption plan |
| lastappliedpolicy |
DATETIME |
Date of application of the assigned policy |
| lastappliedruleset |
DATETIME |
Date of application of the applied rule set |
| lastreported |
DATETIME |
Date of last report to server |
| lastupdatehw |
DATETIME |
Date of last update of hardware information |
| lastupdateloc |
DATETIME |
Date of last location report |
| lastupdatenw |
DATETIME |
Date of last update of network information |
| lastupdatesw |
DATETIME |
Date of last update of software information |
| latitude |
DECIMAL |
Last Reported Latitude |
| longitude |
DECIMAL |
Last Reported Length |
| lostmode* |
BIT |
Flag indicating if Lost Mode is enabled |
| lostmodepassword |
NVARCHAR (20) |
Password to turn off Lost Mode |
| manufacturer |
NVARCHAR (256) |
Device Manufacturer |
| mdmpushmagic |
NVARCHAR (256) |
Security Token for iOS Platform |
| metricsstartdate |
DATETIME |
Metrics Monitoring Start Date |
| model |
NVARCHAR (64) |
Device Model |
| name |
NVARCHAR (256) |
Device Name |
| namefixed |
BIT |
Determine if the device name has been corrected |
| osversion |
NVARCHAR (64) |
Installed OS Version |
| phonenumber |
NVARCHAR (64) |
Active SIM phone number |
| platform_id* |
INT |
Platform ID, reference to the AMDM_DEVICEPLATFORM.platf_id table |
| policy_id |
INT |
Identifier of the policy applied to the device, reference to the AMDM_POLICY.policy_id table |
| policyversion |
INT |
Assigned policy version |
| ruleset_id |
INT |
Rule set identifier applied to the device, reference to AMDM_RULESET.ruleset_id table |
| rulesetversion |
INT |
Version of the applied ruleset |
| serialnumber |
NVARCHAR (128) |
Device serial number |
| simcarrier |
NVARCHAR (64) |
SIM operator at the time of pairing |
| status_id* |
INT |
Device state identifier, reference to AMDM_DEVICESTATUS.devstat_id table |
| totalinternalstorage* |
BIGINT |
Byte size of internal storage |
| tracking* |
INT |
Device tracking level, 0:Do Not Track, 1:Low, 2:Medium, 3:High |
| uniquedeviceidentifier |
NVARCHAR (256) |
Unique device identifier based on your IMEI |
| unlocktoken |
VARCHAR (8000) |
Unlock token for iOS devices |
| user_id* |
INT |
Identifier of the user responsible for the device, reference to the AFW_USERS.user_id table |
| uuidios |
NVARCHAR (256) |
Agent Installation ID for iOS |
| windowsappchanneluri |
NVARCHAR (1024) |
Token for push on Windows |
| windowslastpassword |
VARCHAR (16) |
Last password for account used at Windows device sign-in |
| windowsmdmchanneluri |
NVARCHAR (1024) |
Channel ID for Push in Windows |
| windowsnextnonce |
VARCHAR (128) |
Time in Ticks of Next Push Token Update for Windows |
