ImportedStringMapping Table

The ImportedStringMapping table is used by the importer to keep a history of entities that have been imported from a data source that uses string IDs rather than integer IDs.

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

Database Column

Details

ComplianceConnectionID

Type: integer. Key

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

Category

Type: text (max 100 characters). Key

The importer category applicable for this ID space.

OriginalID

Type: text (max 400 characters). Key

The ID of this entity in the source database.

MappedID

Type: big integer. Generated ID

A unique integer value we can use as an ‘external ID’ safely in the ImportedComputer table.