snmpalias


Description

This table contains Unique custom snmp credentials that are configured for a zone. It also stores alias for common credentials that have responses associated with them. It is parent table that is partitioned over zone schema.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.snmpalias_id_seq'::regclass)
device_snmpalias.snmpalias_id fk_device_alias_alias C

Unique identifier for snmpalias record
zone_id int4 10 null
zone.id fk_snmpalias_zone R

Zone Id for snmpalias record. It maps to system.zone.id
collector_id int4 10 null
collector.id fk_snmpalias_collector R

Collector Id for snmpalias record. It maps to system.collector.id
alias text 2147483647 null

Alias given for this credentials. This is the value that gets displayed on UI
credential text 2147483647 √ null

Credentials for snmpalias record. Credentials are stored in following format. <version of credential(either v2 or v3)>:alias name:encoded credentials.
aliasorder bigserial 19 √ √ nextval('zone.snmpalias_collector_order_seq'::regclass)

Used to order aliases, use the default, do not write directly

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_snmpalias Primary key Asc id
collector_alias_order_idx Must be unique Asc/Asc collector_id + aliasorder
idx_snmpalias_alias Performance Asc alias
uk_snmpalias Must be unique Asc/Asc/Asc zone_id + collector_id + alias

Relationships

Close relationships within degrees of separation