Table sem5.dbo.SEM_AGENT Keeps agents information
|
Generated by SchemaSpy |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
AGENT_ID | Primary key | Asc | PK_SEM_AGENT |
STATUS + DELETED + AGENT_ID | Performance | Asc/Asc/Asc | I_SEM_AGENT_AGENT_ID |
AGENT_VERSION | Performance | Asc | I_SEM_AGENT_AGENT_VERSION |
COMPUTER_ID | Performance | Asc | I_SEM_AGENT_COMPUTER_ID_PLUS |
GROUP_ID | Performance | Asc | I_SEM_AGENT_GRP |
AGENT_ID | Performance | Asc | I_SEM_AGENT_ID_PLUS |
LAST_UPDATE_TIME + AGENT_ID + DELETED | Performance | Asc/Asc/Asc | I_SEM_AGENT_LAST_UPDATE_TIME_PLUS |
PATTERN_IDX + DOMAIN_ID + LAST_SITE_ID | Performance | Asc/Asc/Asc | I_SEM_AGENT_PATTERN_IDX_PLUS |
R_OS_TYPE + DELETED + STATUS + AGENT_ID | Performance | Asc/Asc/Asc/Asc | I_SEM_AGENT_R_OS_TYPE_OUT_OF_DATE |
DELETED + LAST_SITE_ID | Performance | Asc/Asc | I_SEM_AGENT_RT |
STATUS | Performance | Asc | I_SEM_AGENT_STATUS |
USN | Performance | Asc | I_SEM_AGENT_USN |