SoftwareLicenseReservation Table

The SoftwareLicenseReservation table lists all reservations for a license entitlement for an application.

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

Database Column


SoftwareLicense ReservationID

Type: integer. Key. Generated ID

A unique identifier for this reservation.


Type: integer. Key

The application being reserved. Foreign key to the SoftwareTitle table.


Type: integer. Key. Nullable

The license affected by this reservation, null if any license for the application can be consumed. Foreign key to the SoftwareLicense table.


Type: integer. Key

The computer making the reservation. Foreign key to the ComplianceComputer table.


Type: integer. Key. Nullable

The user making the reservation. Foreign key to the ComplianceUser table.


Type: integer

The number of points this reservation will ultimately consume.


Type: text (max 128 characters). Nullable

The operator who created the record.


Type: datetime

The date the record was created.

SoftwareLicense ReservationTypeID

Type: integer

The type of reservation.

SoftwareLicense ReservationStatusID

Type: integer

Stores the status of the reservation