ImportedUser Table
The ImportedUser
table holds all of the end-users which have been retrieved from the source connections.
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.
Database Column |
Details |
---|---|
ComplianceConnectionID
|
Type: integer. Key. Nullable The identifier for a data source connection in the |
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 |
ComplianceUserID
|
Type: integer. Nullable Identifier of the end-user in the |
ComplianceDomainID
|
Type: integer. Nullable Identifier of the domain in the |
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 |
MapUsingEmailAddress
|
Type: boolean Indicates whether or not the user’s email address should be used to try and map it to an existing |