SoftwarePackageUsageDetail¶
Consolidated usage information per software package per user per machine per day. Perform OctoSAM Inventory housekeeping to update this table from UsageDetail.
Fields¶
| Field | Type | Description |
|---|---|---|
| ID | bigint | Internal ID for the SoftwarePackageUsageDetail entity (Primary Key) |
| MachineID | bigint | Internal ID that references the Machine entity (Foreign Key) |
| MachineID | bigint | Internal ID that references the Machine entity (Foreign Key) |
| MachineID | bigint | Internal ID that references the Machine entity (Foreign Key) |
| Minutes | int | Consolidated usage time in minutes per day- |
| Minutes | int | Consolidated usage time in minutes per day- |
| SoftwarePackageID | bigint | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| SoftwarePackageID | bigint | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| UsageDate | datetime2 | Date the usage was detected. Note that the time portion of this column is always 00:00:00,000, This is because .net and older versions of SQL Server do not have a dedicated Date datatype. May change to Date in the future. |
| UsageDate | datetime2 | Date the usage was detected. Note that the time portion of this column is always 00:00:00,000, This is because .net and older versions of SQL Server do not have a dedicated Date datatype. May change to Date in the future. |
| UserID | bigint | Internal ID that references the User entity (Foreign Key) |
| UserID | bigint | Internal ID that references the User entity (Foreign Key) |