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.