ReconcileInstalledSoftwareUsageData Table

This is a staging table for InstalledSoftwareUsage 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 ReconcileInstalledSoftwareUsageData table

Database Column

Details

ComplianceUserID

Type: integer. Key. Nullable

The end-user using the application. Foreign key to the ComplianceUser table.

SoftwareLicenseID

Type: integer. Nullable

The license that covers this installation. Foreign key to the SoftwareLicense table.

SoftwareLicense AllocationID

Type: integer. Key. Nullable

A link to any individual allocation that this installation consumes. Foreign key to the SoftwareLicenseAllocation table.

IsLicensed

Type: boolean

Set this field to True if this usage is licensed.

UsageSessions

Type: integer

The number of sessions for (or times that the application was used by) this end-user on this computer.

UsageActiveTime

Type: integer

The amount of time this application was in active use (in the foreground) for this end-user on this computer.

ComplianceComputerID

Type: integer. Key

The application. Foreign key to the ComplianceComputer table.

SoftwareTitleID

Type: integer. Key

The application. Foreign key to the SoftwareTitle table.

LastUsedDate

Type: datetime. Nullable

The last used date of the application.

AccessModeID

Type: integer. Key

The date that the installed software was last used.