EN
Español
English
Português
    ASM_SOFTWARE_USAGE

    Detailed Software Usage Table

    Data model

    Fields

    Field Type Description
    cpu* TINYINT Amount of CPU used by the software
    device_id* INT Device identifier aam_device.id
    file_id* INT Identifier of aam_file_version.id executable files
    from_date* DATETIME Date you start using software
    id* INT Primary Key Table Identifier
    logon_user_id* INT Logged-in user ID aam_local_user.id
    memory* BIGINT Amount of memory used by the software
    title NVARCHAR (510) Software Window Title
    to_date* DATETIME Date on which the use of the software ends

    Primary Key

    PK_ASM_SOFTWARE_USAGE
    id

    References

    Column Referenced Table Referenced column Name
    device_id* dbo.AAM_DEVICE id FK01_ASM_SOFTWARE_USAGE
    file_id* Bod. AAM_FILE_VERSION id FK02_ASM_SOFTWARE_USAGE
    logon_user_id* dbo.AAM_LOCAL_USER id FK03_ASM_SOFTWARE_USAGE