TrackSoftwareTitle Table

TrackSoftwareTitle stores details related to tracking software usage for a software title.

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

Database Column

Details

TrackSoftwareTitleID

Type: integer. Key. Generated ID

Unique identifier for each record. This field is a foreign key to the SoftwareTitle table.

SoftwareTitleID

Type: integer. Key. Nullable

Identifies the application for which usage is being tracked. This field is a foreign key to the SoftwareTitle table.

SoftwareLicenseID

Type: integer. Key. Nullable

Identifies the license associated with the application. This field is a foreign key to the SoftwareLicense table.

TrackGroupID

Type: integer. Key

Identifies if usage tracking has been activated for the Sample or Enterprise tracking group. This field is a foreign key to the TrackGroup table.

LastTrackStartDate

Type: datetime. Nullable

Date that tracking was last turned on.

LastTrackEndDate

Type: datetime. Nullable

Date that tracking was last turned off. This field may be null if the operator cleared the end date when activating application usage.

TrackEndDueDate

Type: datetime. Nullable

Date that the current tracking period ends. Should be null when IsTracked is False.

IsTracked

Type: boolean. Key

Indicates whether usage tracking is enabled for this application entry.