ImportedActiveSyncDevice Table

FlexNet Manager Suite 2020 R1 (On-Premises)

The ImportedActiveSyncDevice table stores details of ActiveSync partnerships. A partnership is a user/device pair, so there may be multiple rows for one device.

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 ImportedActiveSyncDevice table

Database Column

Details

ComplianceConnectionID

Type: integer. Key. Nullable

The identifier for a data source connection in the ComplianceConnection table.

ExternalID

Type: integer. Key. Generated ID

The identifier used in the source connection for the computer.

ActiveSyncID

Type: text (max 512 characters). Key. Nullable

The EASIdentity presented by the source, a combination of the AD user and the unique device ID.

Domain

Type: text (max 100 characters). Nullable

The domain of the device. This may be a flat name or FQDN.

DeviceID

Type: text (max 100 characters). Nullable

The unique device identifier.

DeviceOS

Type: text (max 100 characters). Nullable

The device operating system.

DeviceModel

Type: text (max 100 characters). Nullable

The device model.

DeviceType

Type: text (max 50 characters). Nullable

The device type.

DeviceUserAgent

Type: text (max 100 characters). Nullable

The device user agent; an ActiveSync client-specific value that may identify the device type.

UserDisplayName

Type: text (max 256 characters). Nullable

The AD user display name.

IMEI

Type: text (max 256 characters). Nullable

IMEI (International Mobile Equipment Identity) is a 15- or 17-digit code that uniquely identifies mobile phone sets. Leave blank (null) for other device types.

PhoneNumber

Type: text (max 128 characters). Nullable

The phone number of the device. Used for mobile devices.

EmailAddress

Type: text (max 256 characters). Nullable

The user’s primary email address.

ExchangeServer

Type: text (max 256 characters). Nullable

The source exchange server for this information.

WhenCreatedUTC

Type: datetime. Nullable

The date/time this partnership was created, in UTC.

LastSyncAttemptTime

Type: datetime. Nullable

The last attempted sync time for this partnership, in UTC.

LastSuccessSync

Type: datetime. Nullable

The last successful sync time for this partnership, in UTC.

FlexNet Manager Suite (On-Premises)

2020 R1