Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
loglevel Table id serial 10 √ nextval('system.loglevel_id_seq'::regclass)
notificationpolicy Table category text 2147483647 √ null
scan_in_progress Table cidrval cidr 2147483647 √ null
dataview Table name text 2147483647 √ null
normalized_vendor Table raw text 2147483647 √ null
attribute_cidr Table time timestamp 29 √ transaction_timestamp()
scan_in_progress Table fetch_count int4 10 √ 0
spectre_timezone View getcurrentimezone text 2147483647 √ null
admap Table superuser bool 1 false
zone Table description text 2147483647 √ null
feed Table pollinterval int4 10 √ null
user_certificate Table dn text 2147483647 null
config Table key text 2147483647 null
feed Table enabled bool 1 √ null
collector Table leakinterface_id int4 10 √ null
interface Table ospf_area int4 10 √ null
notificationpolicy Table regexpolicy text 2147483647 √ null
interface Table packetrate int4 10 1000
loglevel Table target text 2147483647 null
collector Table uuid uuid 2147483647 √ uuid_generate_v1()
interface Table ospf_auth text 2147483647 √ null
interface Table ospf_authtype int4 10 √ null
collector Table externaldnsinterface_id int4 10 √ null
interface Table name text 2147483647 null
feed_config Table value text 2147483647 null
collector Table id serial 10 √ nextval('system.collector_id_seq'::regclass)
interface Table active bool 1 √ null
attributetype Table id serial 10 √ nextval('system.attributetype_id_seq'::regclass)

Unique identifier for attributetype record
feed_config Table feed_id int4 10 null
loglevel Table description text 2147483647 √ null
interface Table ospf_enabled bool 1 √ null
organization Table id serial 10 √ nextval('system.organization_id_seq'::regclass)
attributetype Table system bool 1 √ false

Boolean flag indicating if an attributetype is system defined type. System defined attribute types are present out of the box. Example: target, trusted, avoid, dnsname, ASname
scan_in_progress Table id serial 10 √ nextval('system.scan_in_progress_id_seq'::regclass)
iftype Table name text 2147483647 √ null
user Table name text 2147483647 √ null
role Table organization_id int4 10 √ null
attribute Table time timestamp 29 √ transaction_timestamp()
organization Table description text 2147483647 √ null
iftype Table description text 2147483647 √ null
session Table id text 2147483647 null
user Table aduser bool 1 √ false
organization Table name varchar 40 null
feed Table id serial 10 √ nextval('system.feed_id_seq'::regclass)
system Table type text 2147483647 √ null

System type of the remote system.
system Table id serial 10 √ nextval('system.system_id_seq'::regclass)

The local system will always have an id of 1, and thus the entry can be determined if it the local system by checking to make sure its id is 1. All other systems will have an id greater than 1.
attribute_cidr Table cidrval cidr 2147483647 null
displayinfo Table ycoord float8 17 √ null
macvendor Table hi int4 10 null
user_apikey Table user_id int4 10 null
zone Table organization_id int4 10 null
interface Table id serial 10 √ nextval('system.interface_id_seq'::regclass)
interface Table address macaddr 2147483647 √ null
interface Table config text 2147483647 √ null
ot_vendor Table url text 2147483647 √ null
feed Table lastendtime timestamp 29 √ null
normalized_vendor Table normalized text 2147483647 √ null
displayinfo Table xcoord float8 17 √ null
user Table id serial 10 √ nextval('system.user_id_seq'::regclass)
ot_vendor Table coo text 2147483647 √ null
session Table user_id int4 10 √ null
displayinfo Table longitude float8 17 √ null
loglevel Table level text 2147483647 null
feed Table isrunning bool 1 √ false
notificationpolicy Table priority text 2147483647 √ null
user Table updatenotes hstore 2147483647 √ null
meta Table key text 2147483647 null
attributetype Table devicetag bool 1 √ false

Boolean flag indicating if an attributetype is used for adding custom attributes to device. This flag supports device specific custom attributes and is set to true for device level custom attribute name(labels)
session Table session_end timestamp 29 √ null
role_permission Table permission_id int4 10 null
feed Table username text 2147483647 √ null
feed Table mapping bool 1 √ false
feed Table overwrite bool 1 √ null
system Table name text 2147483647 null

System name that is specified by the user upon initilization of the box.
feed_config Table key text 2147483647 null
feed Table password text 2147483647 √ null
notificationsubscription Table subscribed bool 1 true
admap Table ad _text 2147483647 √ null
macvendor Table id serial 10 √ nextval('system.macvendor_id_seq'::regclass)
system Table lastconnection timestamp 29 √ null

Current time on local server whenever the WebSocket connection is established
attribute Table attributetype_id int4 10 √ null
dataview Table description text 2147483647 √ null
dataview Table content text 2147483647 √ null
system Table uuid text 2147483647 null

System UUID as reported by 'dmidecode -s system-uuid' on systems that support it, otherwise a random uuid from /proc/sys/kernel/random/uuid (written once), and is RFC4122 compliant.
notificationpolicy Table message text 2147483647 √ null
dashboard Table user_id int4 10 √ null
dashboard Table name text 2147483647 null
notificationpolicy Table name text 2147483647 √ null
dataview_link Table link_id int4 10 null
session Table session_start timestamp 29 √ null
user_certificate Table user_id int4 10 null
notificationpolicy Table querypolicy text 2147483647 √ null
session Table source text 2147483647 √ null
interface Table type text 2147483647 √ null
user_certificate Table certificate text 2147483647 null
displayinfo Table latitude float8 17 √ null
macvendor Table prefix text 2147483647 null
notificationsubscription Table id serial 10 √ nextval('system.notificationsubscription_id_seq'::regclass)
interface Table system_id int4 10 null
user Table fullname text 2147483647 √ null
feed_config Table id serial 10 √ nextval('system.feed_config_id_seq'::regclass)
scan_in_progress Table uuid text 2147483647 √ null
feed Table tablename text 2147483647 √ null
notificationsubscription Table priority text 2147483647 √ null
attributetype Table userdefined bool 1 √ false

Boolean flag indicating if an attributetype is added by user. This flag supports zone specific custom attributes and is set to true for zone level as well as device level custom attribute (labels)
user Table superuser bool 1 false
feed Table pipelinename text 2147483647 √ null
notificationsubscription Table email text 2147483647 √ null
ot_vendor Table notes text 2147483647 √ null
enterprise Table vendor text 2147483647 null

IANA tracked Organization
feed Table name text 2147483647 null
macvendor Table vendor text 2147483647 null
notificationpolicy Table notification_type text 2147483647 √ null
feed Table servername text 2147483647 √ null
attribute_cidr Table attribute_id int4 10 √ null
feed Table filename text 2147483647 √ null
notificationsubscription Table notificationpolicy_id int4 10 null
notificationpolicy Table event text 2147483647 √ null
ot_vendor Table category text 2147483647 √ null
attribute Table attribute text 2147483647 √ null
notificationsubscription Table user_id int4 10 √ null
loglevel Table service text 2147483647 null
user_apikey Table key text 2147483647 null
collector Table zone_id int4 10 null
role Table id serial 10 √ nextval('system.role_id_seq'::regclass)
attribute_cidr Table id serial 10 √ nextval('system.attribute_cidr_id_seq'::regclass)
ot_vendor Table macvendor text 2147483647 √ null
session Table systemaddress text 2147483647 √ null
zone Table id serial 10 √ nextval('system.zone_id_seq'::regclass)
iftype Table refs text 2147483647 √ null
user Table hidden bool 1 false
dataview_link Table dataview_id int4 10 null
role_permission Table role_id int4 10 null
user_apikey Table enabled bool 1 true
session Table session_activity timestamp 29 √ null
dashboard Table id serial 10 √ nextval('system.dashboard_id_seq'::regclass)
dataview Table user_id int4 10 √ null
collector Table interface_id int4 10 √ null
system Table version text 2147483647 √ null

Current version of Spectre software that the system is running.
interface Table ipv4 inet 2147483647 √ null
role Table name text 2147483647 null
interface Table ipv6 inet 2147483647 √ null
system Table connection text 2147483647 √ null

Tracks how this system connects to the remote system. If an IP address or hostname is present, this system is the connection initiator. If there is no data in this column, the remote system will connect to this system. The field is populated with the value that is entered when connecting a system, whether that be an IP or hostname.
scan_in_progress Table details text 2147483647 √ null
dataview Table type text 2147483647 √ null
user_role Table user_id int4 10 null
collector Table updatenotes hstore 2147483647 √ null
user_role Table role_id int4 10 null
feed Table autosubscribe bool 1 √ false
attribute_cidr Table attributetype_id int4 10 null
scan_in_progress Table scantype text 2147483647 √ null
notificationsubscription Table zone_id int4 10 √ null
collector Table ipv4 inet 2147483647 √ null
config Table value text 2147483647 √ null
notificationpolicy Table id serial 10 √ nextval('system.notificationpolicy_id_seq'::regclass)
feed Table laststarttime timestamp 29 √ null
interface Table ospf_router_id inet 2147483647 √ null
session Table clientaddress text 2147483647 √ null
dashboard Table gridcontent jsonb 2147483647 √ null
displayinfo Table system_id int4 10 null
notificationpolicy Table isdefault bool 1 √ false
dataview Table id serial 10 √ nextval('system.dataview_id_seq'::regclass)
admap Table role_id int4 10 √ null
iftype Table id int4 10 √ null
permission Table id serial 10 √ nextval('system.permission_id_seq'::regclass)
macvendor Table lo int4 10 null
displayinfo Table label text 2147483647 √ null
scan_in_progress Table created timestamptz 35 √ now()
enterprise Table id int4 10 null

Private Enterprise Number
zone Table updatenotes hstore 2147483647 √ null
permission Table permission text 2147483647 √ null
ifstatus Table status text 2147483647 √ null
feed Table shortname text 2147483647 √ null
notificationsubscription Table subscriptiontype text 2147483647 √ null
feed Table url text 2147483647 √ null
ot_vendor Table class text 2147483647 √ null
dashboard Table description text 2147483647 √ null
zone Table name varchar 40 null
notificationsubscription Table name text 2147483647 √ null
attribute Table id serial 10 √ nextval('system.attribute_id_seq'::regclass)
collector Table name text 2147483647 null
meta Table value text 2147483647 √ null
feed Table key text 2147483647 √ null
displayinfo Table iconfilename text 2147483647 √ 'lumeta-bug.png'::text
collector Table ipv6 inet 2147483647 √ null
attributetype Table type text 2147483647 √ null

Value of attributetype. Example: target, dnsname, any label for custom attribute or device centric attribute/tag. Custom defined (zone level as well as device level) label gets normalized into this column.
ifstatus Table id int4 10 √ null