SoftwareLicenseUsageHistory Table
SoftwareLicenseUsageHistory
records snapshots of software license utilization.
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.
Database Column |
Details |
---|---|
SoftwareLicenseUsage HistoryID
|
Type: integer. Key. Generated ID A unique identifier for each record in this table. |
SnapshotDate
|
Type: datetime Date that the snapshot was recorded and the projected usage was calculated. |
SoftwareLicenseID
|
Type: integer. Key SoftwareLicenseID that identifies the software license. This field is a foreign key to the |
NumberPurchased
|
Type: integer Total number of licenses purchased, as of the Snapshot Date. |
NumberInstalled
|
Type: integer Total number of installations for the license, as of the Snapshot Date. |
NumberUsedActual
|
Type: integer. Nullable Total consumption of the license, as of the Snapshot Date. If application usage is not being tracked, this field is blank. |
NumberUsedProjected
|
Type: integer. Nullable The projected usage calculated for this license, based on patterns of usage over time. |
FlexNet Manager Suite (On-Premises)
2020 R1