attributeconfig

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

zone

text

2147483647

√

null

This column shows the zone name and zone id for which the CIDR belongs to. It is represented as zone name (zone id)

collector

text

2147483647

√

null

This column shows the collector name and collector id for which the CIDR belongs to. It is represented as Collector name (collector id)

cidrval

cidr

2147483647

√

null

This column stores the value of the CIDR

type

text

2147483647

√

null

Indicates the type of CIDR. Default values are set as follows: type is set to target if CIDR belongs to Discovery Spaces => Target List type is set to avoid if CIDR belongs to Discovery Spaces => Avoid List type is set to stop if CIDR belongs to Discovery Spaces => Stop List type is set to trusted if CIDR belongs to Zone Networks => Eligible List type is set to known if CIDR belongs to Zone Networks => Known List type is set to internal if CIDR belongs to Zone Networks => Internal List type is set to user-defined Label when user adds a Custom Attribute

attribute

text

2147483647

√

null

Indicates the attribute value when user adds a Custom Attribute

Table contained 0 rows

View Definition

SELECT config.zone,
    config.collector,
    config.cidrval,
    config.type,
    config.attribute
   FROM ( SELECT ((((z.name)::text || '('::text) || (z.id)::text) || ')'::text) AS zone,
            NULL::text AS collector,
            ac.cidrval,
            att.type,
            a.attribute
           FROM (((system.zone z
             JOIN zone.attribute_cidr ac ON (((ac.zone_id = z.id) AND (ac.collector_id IS NULL))))
             JOIN system.attributetype att ON ((att.id = ac.attributetype_id)))
             LEFT JOIN zone.attribute a ON ((a.id = ac.attribute_id)))
        UNION
         SELECT ((((z.name)::text || '('::text) || (z.id)::text) || ')'::text),
            (((c.name || '('::text) || c.id) || ')'::text),
            ac.cidrval,
            att.type,
            a.attribute
           FROM ((((system.zone z
             JOIN system.collector c ON ((c.zone_id = z.id)))
             JOIN zone.attribute_cidr ac ON ((ac.collector_id = c.id)))
             JOIN system.attributetype att ON ((att.id = ac.attributetype_id)))
             LEFT JOIN zone.attribute a ON ((a.id = ac.attribute_id)))) config
  ORDER BY config.zone, config.collector, config.type, config.cidrval;

Description

Columns

View Definition

Possibly Referenced Tables/Views