wmialias


Description

This table contains unique WMI credentials that are configured for a zone. It is the parent table that is partitioned over zone schema.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('zone.wmialias_id_seq'::regclass)
device_wmialias.wmialias_id fk_device_wmi_alias_alias C

unique identifier for wmialias record
zone_id int4 10 null
zone.id fk_wmialias_zone R

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

Collector Id for wmialias 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 wmialias record. Credentials are stored in following format: alias name:domain:encoded credentials.
aliasorder bigserial 19 √ √ nextval('zone.wmialias_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_wmialias Primary key Asc id
idx_wmialias_alias Performance Asc alias
uk_wmialias Must be unique Asc/Asc/Asc zone_id + collector_id + alias
wmicollector_alias_order_idx Must be unique Asc/Asc collector_id + aliasorder

Relationships

Close relationships within degrees of separation