Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| AgentId | INT | 10 | null |
|
|
|||||
| Version | INT UNSIGNED | 10 | 0 |
|
|
This column stores the version number of the monitor (agent), and should not be manually updated. Instead, allow the AgentsAfterInsert/AgentsAfterDelete/AgentsAfterUpdate (AFTER INSERT/DELETE/UPDATE on agents), DCIncrementVersionOnInsert (AFTER INSERT on DataCollectors) and DCIncrementVersionOnDelete (AFTER DELETE on DataCollectors) triggers perform any and all updates on this column. This column can (and should) also be left blank and it will default to a version of ‘0’. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | AgentId |
Relationships
Close relationships within degrees of separation
