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

Details

ComplianceConnectionID

Type: integer. Key. Generated ID

A unique identifier for a compliance connection.

ConnectionTypeID

Type: integer. Key

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

ConnectionName

Type: text (max 128 characters). Key

The internal, unique name of the connection.

ConnectionNameDisplayName

Type: text (max 64 characters)

The name of the connection for display purposes.

UseFnmpDbServerAsSource

Type: boolean

Use the FNMP database server as the source.

Server

Type: text (max 128 characters). Nullable

The name of the SQL Server.

UseWindowsAuth

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.

Username

Type: text (max 128 characters). Nullable

The username to use when connecting with SQL authentication.

Password

Type: text. Nullable

The password to use when connecting with SQL authentication.

DatabaseName

Type: text (max 128 characters). Nullable

The name of the database to connect to.

ConnectionString

Type: text. Nullable

The connection string used to connect to a datasource.

LastImportDate

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.

LastImportStarted

Type: datetime. Nullable

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

LastImportEnded

Type: datetime. Nullable

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

LastImportSuccessful

Type: boolean

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

SourceType

Type: text (max 256 characters)

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

SourceTypeDisplayName

Type: text (max 128 characters)

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

Signature

Type: text (max 128 characters)

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

PrimaryConnection

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.

TestConnection

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.

Enabled

Type: boolean

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

GroupName

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).

ExpiryPeriod

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.

IsRemote

Type: boolean

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

ConnectionExID

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.

BeaconUID

Type: unique identifier. Key. Nullable

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