Daily Consolidated Software Usage Table
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cpu* | TINYINT | Amount of CPU used by the software |
| date_id* | INT | Table ID [ADW_DIM_DATE].[id] |
| device_id* | INT | Device identifier aam_device.id |
| duration* | BIGINT | Time in seconds of software usage |
| file_id* | INT | Identifier of aam_file_version.id executable files |
| logon_user_id* | INT | Logged-in user ID aam_local_user.id |
| memory* | BIGINT | Amount of memory used by the software |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| date_id* | Bod. ADW_DIM_DATE | id | FK04_ASM_SOFTWARE_USAGE_DAY |
| device_id* | dbo.AAM_DEVICE | id | FK01_ASM_SOFTWARE_USAGE_DAY |
| file_id* | Bod. AAM_FILE_VERSION | id | FK02_ASM_SOFTWARE_USAGE_DAY |
| logon_user_id* | dbo.AAM_LOCAL_USER | id | FK03_ASM_SOFTWARE_USAGE_DAY |