EN
Español
English
Português
    ASM_SOFTWARE_USAGE

    Store detailed software usage by device

    Data model

    Fields

    Field Type Description
    cpu* TINYINT Amount of CPU used by the software
    device_id* INT Unique device identifier
    file_id* INT Unique executable file identifier
    from_date* DATETIME Date you start using software
    id* INT Unique Software Usage Identifier
    logon_user_id* INT Unique identifier of the logged-in user
    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* dbo.AAM_FILE_VERSION id FK02_ASM_SOFTWARE_USAGE
    logon_user_id* dbo.AAM_LOCAL_USER id FK03_ASM_SOFTWARE_USAGE