SoftwareLicenseAllocation Table

SoftwareLicenseAllocation records the allocations of individual computers, end-users, enterprise groups, instances or products to licenses.

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 `SoftwareLicenseAllocation` table
Database Column	Details
`SoftwareLicense AllocationID`	Type: integer. Key. Generated ID A unique identifier for the license allocation record.
`SoftwareLicenseID`	Type: integer. Key The license that has been allocated. Foreign key to the `SoftwareLicense` table.
`ComplianceComputerID`	Type: integer. Key. Nullable The computer to which the license is allocated. Foreign key to the `ComplianceComputer` table.
`SoftwareTitleProductID`	Type: integer. Key. Nullable The software title product to which the license is. Foreign key to the `SoftwareTitleProduct` table.
`ComplianceUserID`	Type: integer. Key. Nullable The end-user to which the license is allocated. Foreign key to the `ComplianceUser` table.
`InstanceID`	Type: integer. Key. Nullable The instance to which the license is allocated. Foreign key to the `Instance` table.
`GroupExID`	Type: text (max 128 characters). Key. Nullable The enterprise group to which the license is assigned. Foreign key to the `GroupEx` table.
`LicenseUserID`	Type: integer. Key. Nullable The external end-user to whom the license is allocated. Foreign key to the `LicenseUser` table.
`AccessingUserID`	Type: integer. Key. Nullable The external accessing user to whom the license is allocated. Foreign key to the `AccessingUser` table.
`SoftwareLicense AllocationUserTypeID`	Type: integer. Key. Nullable Indicates for user allocations whether they are a regular user or some special type of user for this license. Foreign key to the `SoftwareLicenseAllocationUserType` table.
`NumberAllocated`	Type: integer. Nullable The number of license entitlements assigned. This is used for group assignments.
`NumberUsed`	Type: integer. Nullable The number of license entitlements where the application is recorded as being used.
`SoftwareLicense AllocationStatusID`	Type: integer. Nullable Indicates the status of an allocation. Foreign key to the `SoftwareLicenseAllocationStatus` table.
`SoftwareLicenseKeyID`	Type: integer. Key. Nullable The software license key that is allocated to this end-user/computer. Foreign key to the `SoftwareLicenseKey` table.
`SoftwareLicense ExemptionReasonID`	Type: integer. Key. Nullable The reason why this allocation is exempted from consuming a license entitlement. Foreign key to the `SoftwareLicenseExemptionReason` table.
`IsIncludedForLicenseRec`	Type: boolean. Key Indicates allocations whether they should be used in regular license reconciliation.
`AllocationReason`	Type: text (max 256 characters). Nullable The reason explaining why this allocation has been made.
`AllocationFromReport`	Type: boolean. Key Indicates if allocated From Report.
`ExemptionFromReport`	Type: boolean. Key Indicates if exempted From Report.
`AllocationDate`	Type: datetime The date when the allocation was made.