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.
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 |
---|---|
ComplianceUserID
|
Type: integer. Key. Nullable The end-user using the application. Foreign key to the |
SoftwareLicenseID
|
Type: integer. Nullable The license that covers this installation. Foreign key to the |
SoftwareLicense AllocationID
|
Type: integer. Key. Nullable A link to any individual allocation that this installation consumes. Foreign key to the |
IsLicensed
|
Type: boolean Set this field to |
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 |
SoftwareTitleID
|
Type: integer. Key The application. Foreign key to the |
LastUsedDate
|
Type: datetime. Nullable The last used date of the application. |
AccessModeID
|
Type: integer. Key The date that the installed software was last used. |