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 | bigint | Internal ID for the UsageDetail entity (Primary Key) |
| MachineID | bigint | Internal ID that references the Machine entity (Foreign Key) |
| Minutes | int | Usage in minutes |
| ScanDateTime | datetime2 | Date/Time of the .scan file. |
| ScanGUID | uniqueidentifier | GUID of the .scan file that created this record. |
| SoftwareSignatureID | bigint | Internal ID that references the SoftwareSignature entity (Foreign Key) |
| UsageDate | datetime2 | Date this usage was detected. Note that the time portion of this column is always 00:00:00,000. |
| UserID | bigint | Internal ID that references the User entity (Foreign Key) |