ReconcileSoftwareLicenseSecondUseMappingData Table

This is a staging table for SoftwareLicenseSecondUseMapping that is used during license reconciliation process, to store calculated values, and then bulk update the main table.

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

Database Column

Details

SoftwareLicenseID

Type: integer. Key

The license conferring the right of second use. Foreign key to the SoftwareLicense table.

DesktopComputerID

Type: integer. Key

The desktop or primary computer on which the related software in installed. Foreign key to the ComplianceComputer table.

SecondUseComputerID

Type: integer. Key

The laptop or second computer covered by this license’s right of second use, relative to the installation on the primary computer tracked in the previous field. Foreign key to the ComplianceComputer table.

TotalLicenseGrabs

Type: integer

For internal use only. Temporary storage for calculations of overlapping second use and multiple install rights.

IsExternalRoamingLink

Type: boolean

Is this a second use link or is it actually an ‘external roaming’ right?