InstalledSoftwareUsageData Table

InstalledSoftwareUsage records the end-users who are using a piece of software installed on a computer.

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 `InstalledSoftwareUsageData` table
Database Column	Details
`InstalledSoftwareUsageID`	Type: integer. Key. Generated ID The unique identifier for this record.
`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 date that the installed software was last used.
`AccessModeID`	Type: integer. Key The date that the installed software was last used.