EN
Español
English
Português
    AES_DEVICE

    Security Product Devices

    Data model

    Fields

    Field Type Description
    group_id INT Device group ID
    id* UNIQUEIDENTIFIER Device Identifier
    ip* NVARCHAR (4000) Device network address
    last_scan DATETIME2 Vulnerability Report Update Date
    last_updated DATETIME2 Compliance Report Update Date
    name* NVARCHAR (300) Device Name
    operating_system* NVARCHAR (300) Device operating system name
    platform_id* INT Device operating system identifier
    raw_id* NVARCHAR (200) Device Identifier
    state TINYINT Current Compliance Status of Current Policy
    status_date DATETIME2 Date the current state was set
    version VARCHAR (25) Agent version installed

    Primary Key

    PK_AES_DEVICE
    id

    References

    Column Referenced Table Referenced column Name
    group_id dbo.AES_GROUP id FK01_AES_DEVICE
    platform_id* dbo.AES_PLATFORM id FK02_AES_DEVICE