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 | numeric | Internal ID for the SoftwarePackageUsageDetail entity (Primary Key) |
| MachineID | numeric | Internal ID that references the Machine entity (Foreign Key) |
| Minutes | numeric | Consolidated usage time in minutes per day |
| SoftwarePackageID | numeric | Internal ID that references the SoftwarePackage entity (Foreign Key) |
| UsageDate | datetime | 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 | numeric | Internal ID that references the User entity (Foreign Key) |