UsageDetail¶
Holds detailed usage information as imported from octoscan scan files. This table should usually not be referenced directly by reports and queries. Use the consolidated SoftwarePackageUsageDetail table instead.
Fields¶
| Field | Type | Description |
|---|---|---|
| ID | numeric | Internal ID for the UsageDetail entity (Primary Key) |
| MachineID | numeric | Internal ID that references the Machine entity (Foreign Key) |
| Minutes | numeric | Usage in minutes |
| ScanDateTime | datetime | Date/Time of the .scan file |
| ScanGUID | guid | GUID of the .scan file that created this record |
| SoftwareSignatureID | numeric | Internal ID that references the SoftwareSignature entity (Foreign Key) |
| UsageDate | datetime | Date this usage was detected. Note that the time portion of this column is always 00:00:00,000. |
| UserID | numeric | Internal ID that references the User entity (Foreign Key) |