Stores software usage information for each device consolidated by month.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cpu* | TINYINT | CPU Consumption |
| device_id* | INT | Identifier of the associated device. Reference to the AAM_DEVICE.id table |
| duration* | BIGINT | Duration of use in seconds |
| file_id* | INT | Identifier of the associated file. Reference to the AAM_FILE_VERSION.id table |
| id* | INT | Unique Table Identifier |
| logon_user_id* | INT | Identifier of the user who logged in. Reference to the AAM_LOCAL_USER.id table |
| memory* | BIGINT | Memory consumption |
| month* | INT | Month in which the device was used |
| year* | INT | Year in which the device was used |
Primary Key
| PK_ASM_SOFTWARE_USAGE_MONTH |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| device_id* | dbo.AAM_DEVICE | id | FK01_ASM_SOFTWARE_USAGE_MONTH |
| file_id* | Bod. AAM_FILE_VERSION | id | FK02_ASM_SOFTWARE_USAGE_MONTH |
| logon_user_id* | dbo.AAM_LOCAL_USER | id | FK03_ASM_SOFTWARE_USAGE_MONTH |