Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
dataview_link Table dataview_id int4 10 null
session Table systemaddress text 2147483647 √ null
role_permission Table role_id int4 10 null
interface Table ospf_area int4 10 √ null
notificationsubscription Table priority text 2147483647 √ null
attribute_cidr Table id serial 10 √ nextval('system.attribute_cidr_id_seq'::regclass)
permission Table id serial 10 √ nextval('system.permission_id_seq'::regclass)
interface Table address macaddr 2147483647 √ null
feed Table laststarttime timestamp 29 √ null
macvendor Table lo int4 10 null
user_certificate Table dn text 2147483647 null
displayinfo Table latitude float8 17 √ null
user Table hidden bool 1 false
dataview Table id serial 10 √ nextval('system.dataview_id_seq'::regclass)
loglevel Table id serial 10 √ nextval('system.loglevel_id_seq'::regclass)
macvendor Table prefix text 2147483647 null
spectre_timezone View getcurrentimezone text 2147483647 √ null
user_role Table role_id int4 10 null
user_apikey Table enabled bool 1 true
interface Table ospf_auth text 2147483647 √ null
feed Table autosubscribe bool 1 √ false
collector Table updatenotes hstore 2147483647 √ null
interface Table type text 2147483647 √ null
notificationpolicy Table message text 2147483647 √ null
feed Table pollinterval int4 10 √ null
user_role Table user_id int4 10 null
interface Table system_id int4 10 null
feed Table enabled bool 1 √ null
feed Table isrunning bool 1 √ false
session Table session_start timestamp 29 √ null
zone Table id serial 10 √ nextval('system.zone_id_seq'::regclass)
dashboard Table description text 2147483647 √ null
interface Table packetrate int4 10 1000
macvendor Table vendor text 2147483647 null
feed Table filename text 2147483647 √ null
feed Table url text 2147483647 √ null
displayinfo Table ycoord float8 17 √ null
notificationsubscription Table subscribed bool 1 true
interface Table id serial 10 √ nextval('system.interface_id_seq'::regclass)
interface Table active bool 1 √ null
dataview Table type text 2147483647 √ null
permission Table permission text 2147483647 √ null
dataview Table description text 2147483647 √ null
feed_config Table feed_id int4 10 null
session Table id text 2147483647 null
notificationpolicy Table notification_type text 2147483647 √ null
notificationpolicy Table category text 2147483647 √ null
feed_config Table id serial 10 √ nextval('system.feed_config_id_seq'::regclass)
collector Table interface_id int4 10 √ null
notificationsubscription Table zone_id int4 10 √ null
feed Table username text 2147483647 √ null
organization Table id serial 10 √ nextval('system.organization_id_seq'::regclass)
attributetype Table id serial 10 √ nextval('system.attributetype_id_seq'::regclass)
admap Table ad _text 2147483647 √ null
collector Table uuid uuid 2147483647 √ uuid_generate_v1()
notificationsubscription Table subscriptiontype text 2147483647 √ null
interface Table ospf_authtype int4 10 √ null
interface Table name text 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.
dashboard Table gridcontent jsonb 2147483647 √ null
role Table organization_id int4 10 √ null
attribute_cidr Table attributetype_id int4 10 null
notificationsubscription Table user_id int4 10 √ null
collector Table zone_id int4 10 null
user_apikey Table user_id int4 10 null
displayinfo Table iconfilename text 2147483647 √ 'lumeta-bug.png'::text
config Table value text 2147483647 √ null
loglevel Table service text 2147483647 null
system Table version text 2147483647 √ null

Current version of Spectre software that the system is running.
attribute Table time timestamp 29 √ transaction_timestamp()
normalized_vendor Table normalized text 2147483647 √ null
notificationsubscription Table notificationpolicy_id int4 10 null
meta Table value text 2147483647 √ null
notificationpolicy Table isdefault bool 1 √ false
feed Table servername text 2147483647 √ null
session Table user_id int4 10 √ null
enterprise Table vendor text 2147483647 null

IANA tracked Organization
interface Table ospf_enabled bool 1 √ null
notificationpolicy Table regexpolicy text 2147483647 √ null
feed Table lastendtime timestamp 29 √ null
session Table source text 2147483647 √ null
attribute_cidr Table cidrval cidr 2147483647 null
feed Table id serial 10 √ nextval('system.feed_id_seq'::regclass)
dataview Table name text 2147483647 √ null
loglevel Table description text 2147483647 √ null
notificationpolicy Table priority text 2147483647 √ null
meta Table key text 2147483647 null
attribute_cidr Table attribute_id int4 10 √ null
feed Table overwrite bool 1 √ null
dashboard Table user_id int4 10 √ null
collector Table id serial 10 √ nextval('system.collector_id_seq'::regclass)
dataview Table content text 2147483647 √ null
collector Table ipv4 inet 2147483647 √ null
system Table name text 2147483647 null

System name that is specified by the user upon initilization of the box.
notificationsubscription Table email text 2147483647 √ null
role_permission Table permission_id int4 10 null
notificationpolicy Table name text 2147483647 √ null
attributetype Table type text 2147483647 √ null
displayinfo Table system_id int4 10 null
notificationpolicy Table id serial 10 √ nextval('system.notificationpolicy_id_seq'::regclass)
notificationsubscription Table id serial 10 √ nextval('system.notificationsubscription_id_seq'::regclass)
user Table fullname text 2147483647 √ null
zone Table description text 2147483647 √ null
feed Table tablename text 2147483647 √ null
loglevel Table level text 2147483647 null
role Table name text 2147483647 null
notificationsubscription Table name text 2147483647 √ null
attributetype Table userdefined bool 1 √ false
admap Table superuser bool 1 false
attribute Table id serial 10 √ nextval('system.attribute_id_seq'::regclass)
session Table session_activity timestamp 29 √ null
dataview Table user_id int4 10 √ null
attribute_cidr Table time timestamp 29 √ transaction_timestamp()
attribute Table attributetype_id int4 10 √ null
role Table id serial 10 √ nextval('system.role_id_seq'::regclass)
system Table type text 2147483647 √ null

System type of the remote system.
zone Table organization_id int4 10 null
dashboard Table id serial 10 √ nextval('system.dashboard_id_seq'::regclass)
user Table name text 2147483647 √ null
user Table aduser bool 1 √ false
feed Table mapping bool 1 √ false
dashboard Table name text 2147483647 null
collector Table ipv6 inet 2147483647 √ null
interface Table ipv4 inet 2147483647 √ null
session Table session_end timestamp 29 √ null
organization Table description text 2147483647 √ null
admap Table role_id int4 10 √ null
interface Table ospf_router_id inet 2147483647 √ null
user Table superuser bool 1 false
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.
enterprise Table id int4 10 null

Private Enterprise Number
session Table clientaddress text 2147483647 √ null
loglevel Table target text 2147483647 null
system Table lastconnection timestamp 29 √ null

Current time on local server whenever the WebSocket connection is established
feed Table password text 2147483647 √ null
displayinfo Table longitude float8 17 √ null
dataview_link Table link_id int4 10 null
zone Table name varchar 40 null
user Table updatenotes hstore 2147483647 √ null
feed_config Table value text 2147483647 null
collector Table externaldnsinterface_id int4 10 √ null
user_certificate Table certificate text 2147483647 null
feed Table name text 2147483647 null
interface Table config text 2147483647 √ null
user Table id serial 10 √ nextval('system.user_id_seq'::regclass)
macvendor Table id serial 10 √ nextval('system.macvendor_id_seq'::regclass)
organization Table name varchar 40 null
notificationpolicy Table querypolicy text 2147483647 √ null
feed Table shortname text 2147483647 √ null
feed Table key text 2147483647 √ null
user_certificate Table user_id int4 10 null
displayinfo Table xcoord float8 17 √ null
attributetype Table system bool 1 √ false
user_apikey Table key text 2147483647 null
normalized_vendor Table raw text 2147483647 √ null
zone Table updatenotes hstore 2147483647 √ null
collector Table leakinterface_id int4 10 √ null
notificationpolicy Table event text 2147483647 √ null
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.
interface Table ipv6 inet 2147483647 √ null
displayinfo Table label text 2147483647 √ null
macvendor Table hi int4 10 null
feed_config Table key text 2147483647 null
config Table key text 2147483647 null
attribute Table attribute text 2147483647 √ null
collector Table name text 2147483647 null
feed Table pipelinename text 2147483647 √ null