ComplianceUserSnapshot Table

The ComplianceUserSnapshot table lists all the users for each snapshot.

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

Database Column

Details

ComplianceUserID

Type: integer. Key

The snapshotted ComplianceUserID.

UserName

Type: text (max 256 characters). Nullable

The snapshotted user name.

Domain

Type: text (max 256 characters). Nullable

The snapshotted user domain name.

LocationID

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

The snapshotted LocationID.

BusinessUnitID

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

The snapshotted BusinessUnitID.

CostCenterID

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

The snapshotted CostCenterID.

CategoryID

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

The snapshotted CategoryID.

LicenseMeasurementID

Type: integer. Key

The snapshot ID. Foreign key to the LicenseMeasurement table.