ImportedUser Table

The ImportedUser table holds all of the end-users which have been retrieved from the source connections.

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

Database Column

Details

ComplianceConnectionID

Type: integer. Key. Nullable

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

ExternalID

Type: big integer. Key. Nullable

The identifier used in the source connection for the end-user.

UserName

Type: text (max 64 characters). Nullable

The account name of the end-user.

Domain

Type: text (max 100 characters). Key. Nullable

The domain of the end-user.

SAMAccountName

Type: text (max 64 characters). Key. Nullable

The SAM account name of the end-user.

InventoryAgent

Type: text (max 64 characters). Nullable

The name of the person or tool that performed the last inventory. For imported spreadsheets, you may wish to include the name of the person preparing the data, in case there is subsequent follow-up required.

FirstName

Type: text (max 128 characters). Nullable

The first name of the end-user.

LastName

Type: text (max 128 characters). Nullable

The last name or surname of the end-user.

Email

Type: text (max 200 characters). Nullable

The email address of the end-user.

EmployeeNumber

Type: text (max 128 characters). Nullable

The employee number of the end-user.

CostCenter

Type: text (max 128 characters). Nullable

The cost center of the end-user, as reported in SAP. Does not necessarily map to a cost centre in the GroupEx table.

ComplianceUserID

Type: integer. Nullable

Identifier of the end-user in the ComplianceUser table that this imported user links to. This is populated by the import process and does not need to be provided by the source connections.

ComplianceDomainID

Type: integer. Nullable

Identifier of the domain in the ComplianceDomain table that this end-user belongs to. This is populated by the import process and does not need to be provided by the source connections.

IsBlacklisted

Type: boolean. Key

This is populated by the import process and does not need to be provided by the source connections. The field is set to True if the end-user matches a record from the UserNameBlacklist table, meaning the account should not be included in compliance calculations.

MapUsingEmailAddress

Type: boolean

Indicates whether or not the user’s email address should be used to try and map it to an existing ComplianceUser record.