Stores detailed daily software usage information per window
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cpu* | TINYINT | Percentage of CPU Used by Software |
| date_id* | INT | Date Identifier |
| device_id* | INT | Device Identifier |
| duration* | INT | Time in seconds of software usage |
| file_id* | INT | Executable file identifier |
| logon_user_id* | INT | Identifier of the user authenticated in the operating system at the time of capturing the use of the software |
| memory* | BIGINT | Byte size of memory localized by the software |
| window_info_id* | INT | Unique identifier of the window associated with a software process |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| date_id* | Bod. ADW_DIM_DATE | id | FK04_ASM_SOFTWARE_USAGE_DETAIL |
| device_id* | dbo.AAM_DEVICE | id | FK01_ASM_SOFTWARE_USAGE_DETAIL |
| file_id* | Bod. AAM_FILE_VERSION | id | FK02_ASM_SOFTWARE_USAGE_DETAIL |
| logon_user_id* | dbo.AAM_LOCAL_USER | id | FK03_ASM_SOFTWARE_USAGE_DETAIL |
| window_info_id* | dbo.ASM_WINDOW_INFORMATION | id | FK05_ASM_SOFTWARE_USAGE_DETAIL |