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.
`UseCyberArk`	Type: boolean Specify whether to fetch credentails for SQL authentication from CyberArk.
`CyberArkQuery`	Type: text. Nullable The query string used to fetch credentials for SQL authentication from CyberArk.
`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.
`UseSecurePassword`	Type: boolean Specify whether to use the secured password for the connection string, either by using an encrypted password stored locally or by retrieving it from CyberArk.
`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.