MobileDevice Table

MobileDevice extends the ComplianceComputer table to store mobile device related property values.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for MobileDevice table

Database Column

Details

MobileDeviceID

Type: integer. Key. Generated ID

A unique identifier for a MobileDevice Column use to specify clustered index.

ComplianceComputerID

Type: integer. Key

A unique identifier for a MobileDevice. Foreign key to the ComplianceComputer table.

IMEI

Type: text (max 256 characters). Nullable

IMEI value of the mobile device.

PhoneNo

Type: text (max 128 characters). Nullable

Phone number of the mobile device.

EmailAddress

Type: text (max 256 characters). Nullable

The stmp email account associated to a mobile device when the device is connected to ActiveSync.