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.
erDiagram
Machine ||--o{ UsageDetail : "MachineID"
SoftwareSignature ||--o{ UsageDetail : "SoftwareSignatureID"
User ||--o{ UsageDetail : "UserID"
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) |
References
| Column Name |
Referenced Table |
Description |
| MachineID |
Machine |
Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet. |
| SoftwareSignatureID |
SoftwareSignature |
A software signature is a unique pattern detected by software scan, like a fingerprint that a particular software leaves on machines. |
| UserID |
User |
Basic user Information |