ComplianceConnection Table

The ComplianceConnection table stores details about databases configured for use in compliance imports, such as Microsoft SMS.

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

Database Column



Type: integer. Key. Generated ID

A unique identifier for a compliance connection.


Type: integer. Key

The compliance connection type. Foreign key to the ConnectionType table.


Type: text (max 128 characters). Key

The internal, unique name of the connection.


Type: text (max 64 characters)

The name of the connection for display purposes.


Type: boolean

Use the FNMP database server as the source.


Type: text (max 128 characters). Nullable

The name of the SQL Server.


Type: boolean. Nullable

If this field is set to True, the connection will use Windows authentication when connecting to the database. If False, SQL authentication will be used.


Type: text (max 128 characters). Nullable

The username to use when connecting with SQL authentication.


Type: text. Nullable

The password to use when connecting with SQL authentication.


Type: text (max 128 characters). Nullable

The name of the database to connect to.


Type: text. Nullable

The connection string used to connect to a datasource.


Type: datetime. Nullable

Date and time when data from this data source was successfully imported into the staging area (reader execution). The imported data may not have been applied to the core tables.


Type: datetime. Nullable

Date and time when the import from this data source started.


Type: datetime. Nullable

Date and time when the import from this data source ended.


Type: boolean

Whether or not the last import attempted for this datasource succeeded or failed.


Type: text (max 256 characters)

The source database type (one of several predefined values, such as ManageSoft or SMS).


Type: text (max 128 characters)

A version of the SourceType field, that has been scoped to be specific to this connection.


Type: text (max 128 characters)

A connection signature optionally given by the source database. This allows the source database to identify its connection.


Type: boolean. Key

Set this to True if this is the primary data source to import from. If computers or users exist in multiple connections, data from the primary connection is always given precedence.


Type: boolean

Indicate if this connection is a test connection. If this is set to True writer will not populate target FNMP tables with data in the imported tables from this connection. If this is set to False writer will populate data from this connection as is. Compliance Reader Editor UI sets connection as test so that test data would not accidentally be written to target FNMP tables.


Type: boolean

Indicate if this connection is enabled. If this is set to False reader will not import data from this connection.


Type: text (max 256 characters). Nullable

The GroupName represents subgroups of data from the source. For example, for a citrix connection, this stores a farm name. If this is Null, then there is no sub-grouping (import all).


Type: integer. Nullable

The number of days before considering records in ImportedComputer to be out of date and should be considered stale. NULL means use the Compliance Setting value StaleInventoryThreshold. 0 means always include device data regardless of age.

PerformStaleInventory Check

Type: boolean

Indicates if this connection needs to have the inventory checked to see if data is considered stale. It is reset to 1 after completing the reader’s step of an import.


Type: boolean

Is this a remote connection, where the source side of the readers are running on a remote location (an Inventory Beacon)?


Type: unique identifier. Key

The externally unique identifier for this connection, that can be used by both an Inventory Beacon and the server to track a connection.


Type: unique identifier. Key. Nullable

The unique ID of the beacon where this connection is running.