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