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



Type: integer. Key. Nullable

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


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.


Type: boolean

Set this field to True if this usage is licensed.


Type: integer

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


Type: integer

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


Type: integer. Key

The application. Foreign key to the ComplianceComputer table.


Type: integer. Key

The application. Foreign key to the SoftwareTitle table.


Type: datetime. Nullable

The last used date of the application.


Type: integer. Key

The date that the installed software was last used.