Table sem5.dbo.ALERTS Keeps the risk and Proactive Threat Protection (TruScan) events
|
Generated by SchemaSpy |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
IDX | Primary key | Asc | PK_ALERTS |
MOTHER_IDX + DELETED | Performance | Asc/Asc | A_ALERTS_MOTHER_IDX_PLUS |
ACTUALACTION_IDX + MOTHER_IDX | Performance | Asc/Asc | I_ALERTS_ACTUALACTION_IDX_PLUS |
ALERT_IDX | Performance | Asc | I_ALERTS_ALERT_IDX |
ALERTDATETIME + DELETED | Performance | Asc/Asc | I_ALERTS_ALERTDATETIME_DEL |
ALERTDATETIME + MOTHER_IDX + DELETED + ALERT_IDX | Performance | Asc/Asc/Asc/Asc | I_ALERTS_ALERTDATETIME_PLUS |
ALERTINSERTTIME | Performance | Asc | I_ALERTS_ALERTINSERTTIME |
CLIENTGROUP_IDX | Performance | Asc | I_ALERTS_CLIENTGROUP_IDX |
COMPUTER_IDX | Performance | Asc | I_ALERTS_COMPUTER_IDX |
HPP_APP_IDX | Performance | Asc | I_ALERTS_HPP_APP_IDX |
LAST_LOG_SESSION_GUID | Performance | Asc | I_ALERTS_LAST_LOG_SESSION_GUID_PLUS |
MOTHER_IDX | Performance | Asc | I_ALERTS_MOTHER_IDX |
PARENTSERVER_IDX | Performance | Asc | I_ALERTS_PARENTSERVER_IDX |
REQUESTEDACTION_IDX | Performance | Asc | I_ALERTS_REQUESTEDACTION_IDX |
SERVERGROUP_IDX | Performance | Asc | I_ALERTS_SERVERGROUP_IDX |
SOURCE + ALERT_IDX | Performance | Asc/Asc | I_ALERTS_SOURCE |
SOURCE + ALERT_IDX + MOTHER_IDX + ALERTDATETIME + DELETED + COMPUTER_IDX | Performance | Asc/Asc/Asc/Asc/Asc/Asc | I_ALERTS_SOURCE_ALERT_IDX |
SOURCE + DELETED + ALERTDATETIME + MOTHER_IDX | Performance | Asc/Asc/Asc/Asc | I_ALERTS_SOURCE_PLUS |