ImportedSoftwareLicenseAllocation Table

The ImportedSoftwareLicenseAllocation table holds the links between licenses and 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 `ImportedSoftwareLicenseAllocation` table
Database Column	Details
`ComplianceConnectionID`	Type: integer. Key. Nullable The identifier for a data source connection in the `ComplianceConnection` table.
`ExternalLicenseID`	Type: big integer. Key. Nullable The identifier used in the source connection for the license. Foreign key to the `ImportedSoftwareLicense` table.
`ExternalUserID`	Type: big integer. Key. Nullable The identifier used in the source connection for the user. Foreign key to the `ImportedUser` table.
`ExternalAccessingUserID`	Type: big integer. Key. Nullable The identifier used in the source connection for the accessing user. Foreign key to the `ImportedAccessingUser` table.