SoftwarePackageUsageDetail
Consolidated usage information per software package per user per machine per day. Perform OctoSAM Inventory housekeeping to update this table from UsageDetail.
erDiagram
Machine ||--o{ SoftwarePackageUsageDetail : "MachineID"
SoftwarePackage ||--o{ SoftwarePackageUsageDetail : "SoftwarePackageID"
User ||--o{ SoftwarePackageUsageDetail : "UserID"
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) |
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. |
| SoftwarePackageID |
SoftwarePackage |
A software package defines a logical software entity. A software package can own 0 to n software signatures. |
| UserID |
User |
Basic user Information |