You can download offline version here here.

Introduction

TBD

Tables

ACCESS_POINTS

List of known access points, as collected from wireless controllers.

Table 1. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

ID of the object. Reference to OBJECT_PROPERTIES.

node_id

INTEGER

NOT NULL

βˆ…

ID of the Node object representing this access point. Reference to id field in NODES.

mac_address

VARCHAR(12)

NULL

βˆ…

Access point mac address

vendor

VARCHAR(64)

NULL

βˆ…

Access point vendor

model

VARCHAR(128)

NULL

βˆ…

Access point model

serial_number

VARCHAR(64)

NULL

βˆ…

Access point serial number

ap_state

INTEGER

NOT NULL

βˆ…

Current state of the access point

ap_index

INTEGER

NOT NULL

βˆ…

Reserved for future use

Table 2. Indexes

Name

Type

Fields

access_points_pkey

UNIQUE

id

ACL

Access control for objects (nodes, containers, etc.). Does not keep actual permissions for all objects. Effective rights are calculated in the runtime by the server based on the ACL inheritance setting and hierarchy.

Table 3. Columns

Name

Type

State

Default

Description

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

ID of the object. Reference to OBJECT_PROPERTIES.

πŸ”‘user_id

INTEGER

NOT NULL

βˆ…

ID of the user or group. Reference to USERS or USER_GROUPS.

access_rights

INTEGER

NOT NULL

βˆ…

Bitmask of the permissions. Possible flags:

  • 0x00000001 – Read

  • 0x00000002 – Modify

  • 0x00000004 – Create child objects

  • 0x00000008 – Delete

  • 0x00000010 – View alarms

  • 0x00000020 – Access control

  • 0x00000040 – Update alarms

  • 0x00000080 – Send events

  • 0x00000100 – Control

  • 0x00000200 – Terminate alarms

  • 0x00000400 – Push data

  • 0x00000800 – Create helpdesk tickets

  • 0x00001000 – Download files

  • 0x00002000 – Upload files

  • 0x00004000 – Manage files (renamed, delete, etc.)

  • 0x00008000 – Control maintenance mode

Table 4. Indexes

Name

Type

Fields

acl_pkey

UNIQUE

object_id,user_id

ACTIONS

Server actions used in event processing.

Table 5. Columns

Name

Type

State

Default

Description

πŸ”‘action_id

INTEGER

NOT NULL

βˆ…

Action ID.

action_name

VARCHAR(63)

NOT NULL

βˆ…

Name of the action.

action_type

INTEGER

NOT NULL

βˆ…

Type of the action:

  • 0 – Execute command on the management server

  • 1 – Execute command on the remote agent

  • 2 – Send email

  • 3 – Send SMS

  • 4 – Forward event to another server

  • 5 – Run NXSL script

  • 6 – Send XMPP (Jabber) message

is_disabled

INTEGER

NOT NULL

βˆ…

State of the action:

  • 0 – Enabled

  • 1 – Disabled

rcpt_addr

VARCHAR(255)

NULL

βˆ…

Recepient address for SMS and email actions.

email_subject

VARCHAR(255)

NULL

βˆ…

Subject line for email action.

action_data

TEXT

NULL

βˆ…

Action data field. Meaning depends on the action type. For email/SMS – message body, for server execute – path to the application, etc.

guid

VARCHAR(36)

NOT NULL

βˆ…

Action GUID

Table 6. Indexes

Name

Type

Fields

actions_pkey

UNIQUE

action_id

ADDRESS_LISTS

List of network ranges and subnets used by network discovery.

Table 7. Columns

Name

Type

State

Default

Description

πŸ”‘list_type

INTEGER

NOT NULL

βˆ…

Purpose of the record:

  • 1 - Active discovery target

  • 2 - Address discovery filter

πŸ”‘community_id

INTEGER

NOT NULL

βˆ…

Reserved for future use

πŸ”‘addr_type

INTEGER

NOT NULL

βˆ…

Type of the record:

  • 0 - Subnet, field addr2 indicates netmask in CIDR format

  • 1 - Range, field addr2 indicates end of the range

πŸ”‘addr1

VARCHAR(48)

NOT NULL

βˆ…

Network address or start of the range address.

πŸ”‘addr2

VARCHAR(48)

NOT NULL

βˆ…

Network mark in CIDR format orΒ end of the range address.

zone_uin

INTEGER

NOT NULL

βˆ…

Zone unique identification number from ZONES

proxy_id

INTEGER

NOT NULL

βˆ…

Node id from NODES

Table 8. Indexes

Name

Type

Fields

idx_address_lists_list_type

NORMAL

list_type

address_lists_pkey

UNIQUE

list_type,community_id,addr_type,addr1,addr2

AGENT_CONFIGS

Server side configuration files for the agents.

Table 9. Columns

Name

Type

State

Default

Description

πŸ”‘config_id

INTEGER

NOT NULL

βˆ…

Unique identifier

config_name

VARCHAR(255)

NOT NULL

βˆ…

Description of the configuration file

config_file

TEXT

NOT NULL

βˆ…

Content of the configuration file

config_filter

TEXT

NOT NULL

βˆ…

NXSL script which decide if this configuration is right for incoming agent request.

sequence_number

INTEGER

NOT NULL

βˆ…

Used to sort configurations.

Table 10. Indexes

Name

Type

Fields

agent_configs_pkey

UNIQUE

config_id

AGENT_PKG

List of the agent upgrade packages stored on the server and available for deploy.

Table 11. Columns

Name

Type

State

Default

Description

πŸ”‘pkg_id

INTEGER

NOT NULL

βˆ…

Unique identifier

pkg_name

VARCHAR(63)

NULL

βˆ…

Name of the package (e.g. "nxagent"), as loaded from NPI file.

version

VARCHAR(31)

NULL

βˆ…

Version of the package, as loaded from NPI file.

platform

VARCHAR(63)

NULL

βˆ…

Supported plarform of the package, as loaded from NPI file.

pkg_file

VARCHAR(255)

NULL

βˆ…

Name of the binary file in server storage.

description

VARCHAR(255)

NULL

βˆ…

Description of the package, as loaded from NPI file.

Table 12. Indexes

Name

Type

Fields

agent_pkg_pkey

UNIQUE

pkg_id

ALARM_CATEGORIES

Alarm categories

Table 13. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Category ID

name

VARCHAR(63)

NULL

βˆ…

Category name

descr

VARCHAR(255)

NULL

βˆ…

Category description

Table 14. Indexes

Name

Type

Fields

alarm_categories_pkey

UNIQUE

id

ALARM_CATEGORY_ACL

Access control for alarm categories. Presense of the record in this table give user (or group) access to alarms in specific category.

Table 15. Columns

Name

Type

State

Default

Description

πŸ”‘category_id

INTEGER

NOT NULL

βˆ…

Category ID

πŸ”‘user_id

INTEGER

NOT NULL

βˆ…

User or group ID. Reference to USERS or USER_GROUPS.

Table 16. Indexes

Name

Type

Fields

alarm_category_acl_pkey

UNIQUE

category_id,user_id

ALARM_CATEGORY_MAP

Relation between alarms and alarm categories.

Table 17. Columns

Name

Type

State

Default

Description

πŸ”‘alarm_id

INTEGER

NOT NULL

βˆ…

ID of the alarm. Reference to ALARMS.

πŸ”‘category_id

INTEGER

NOT NULL

βˆ…

ID of the alarm category. Reference to ALARM_CATEGORIES.

Table 18. Indexes

Name

Type

Fields

alarm_category_map_pkey

UNIQUE

alarm_id,category_id

ALARM_EVENTS

History of all events which resulted in generating alarm.

Table 19. Columns

Name

Type

State

Default

Description

πŸ”‘alarm_id

INTEGER

NOT NULL

βˆ…

ID of the alarm. Reference to ALARMS.

πŸ”‘event_id

BIGINT

NOT NULL

βˆ…

Event ID. Reference to EVENT_LOG.

event_code

INTEGER

NOT NULL

βˆ…

Event code. Reference to EVENT_CFG.

event_name

VARCHAR(63)

NULL

βˆ…

Name of the event at the moment of generation.

severity

INTEGER

NOT NULL

βˆ…

Severity of the event at the moment of generation.

source_object_id

INTEGER

NOT NULL

βˆ…

ID of the object which originated the event. Can be reference to NODES, CLUSTERS, etc.

event_timestamp

INTEGER

NOT NULL

βˆ…

Unix time stamp of the event.

message

VARCHAR(2000)

NULL

βˆ…

Event message.

Table 20. Indexes

Name

Type

Fields

idx_alarm_events_alarm_id

NORMAL

alarm_id

alarm_events_pkey

UNIQUE

alarm_id,event_id

ALARM_NOTES

Alarm comments.

Table 21. Columns

Name

Type

State

Default

Description

πŸ”‘note_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

alarm_id

INTEGER

NOT NULL

βˆ…

ID of the alarm. Reference to ALARMS.

change_time

INTEGER

NOT NULL

βˆ…

Unix time stamp of last change.

user_id

INTEGER

NOT NULL

βˆ…

Author of the comment. Reference to USERS.

note_text

TEXT

NULL

βˆ…

Comment body.

Table 22. Indexes

Name

Type

Fields

idx_alarm_notes_alarm_id

NORMAL

alarm_id

alarm_notes_pkey

UNIQUE

note_id

ALARMS

List of all generated alarms regardless of the state. Cleaned up automatically by the housekeeper.

Table 23. Columns

Name

Type

State

Default

Description

πŸ”‘alarm_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

alarm_state

INTEGER

NOT NULL

βˆ…

State of the alarm:

  • 0x00 - Outstanding

  • 0x01 - Acknowledged

  • 0x02 - Resolved

  • 0x03 - Terminated

  • 0x11 - Sticky Acknowledged

hd_state

INTEGER

NOT NULL

βˆ…

State of the related helpdesk ticket (if any):

  • 0 - Ignored (default when no ticket is created from alarm)

  • 1 - Open

  • 2 - Closed

hd_ref

VARCHAR(63)

NULL

βˆ…

Helpdesk ticket id.

creation_time

INTEGER

NOT NULL

βˆ…

Unix time stamp of alarm creation.

last_change_time

INTEGER

NOT NULL

βˆ…

Unix time stamp of last modification.

source_object_id

INTEGER

NOT NULL

βˆ…

Source object of the event which resulted in an alarm. Reference to NODES, CLUSTERS, etc.

source_event_code

INTEGER

NOT NULL

βˆ…

Event code of the event which resulted in an alarm. Reference to EVENT_CFG.

source_event_id

BIGINT

NOT NULL

βˆ…

ID of the event which resulted in an alarm. Reference to EVENT_LOG.

dci_id

INTEGER

NOT NULL

βˆ…

ID of the related data collection item or 0 if event was not generated by threshold violation. Reference to ITEMS.

message

VARCHAR(2000)

NULL

βˆ…

Alarm message.

original_severity

INTEGER

NOT NULL

βˆ…

Alarm severity when alarm was generated.

current_severity

INTEGER

NOT NULL

βˆ…

Current alarm severity. May differ from current_severity if alarm was repeated.

repeat_count

INTEGER

NOT NULL

βˆ…

Number of repeated events with the same alarm_key.

alarm_key

VARCHAR(255)

NULL

βˆ…

Alarm key.

ack_by

INTEGER

NOT NULL

βˆ…

User, who acknowledged this alarm. Reference to USERS.

resolved_by

INTEGER

NOT NULL

βˆ…

User, who resolved this alarm. Reference to USERS.

term_by

INTEGER

NOT NULL

βˆ…

User, who terminated this alarm. Reference to USERS.

timeout

INTEGER

NOT NULL

βˆ…

Alarm timeout in seconds.

timeout_event

INTEGER

NOT NULL

βˆ…

Code of the event which should be send if alarm_state remains in Outstanding state for timeout seconds.

ack_timeout

INTEGER

NOT NULL

βˆ…

Timeout for sticky acknowledgement.

alarm_category_ids

VARCHAR(255)

NULL

βˆ…

Comma-separated list of related alarm categories. Reference to ALARM_CATEGORIES.

zone_uin

INTEGER

NULL

βˆ…

Zone unique identification number from ZONES

Table 24. Indexes

Name

Type

Fields

alarms_pkey

UNIQUE

alarm_id

AP_BINDINGS

Agent policies to node binding

Table 25. Columns

Name

Type

State

Default

Description

πŸ”‘policy_id

INTEGER

NOT NULL

βˆ…

Unique policy identifier from AP_COMMON

πŸ”‘node_id

INTEGER

NOT NULL

βˆ…

Unique node identifier from NODES

Table 26. Indexes

Name

Type

Fields

ap_bindings_pkey

UNIQUE

policy_id,node_id

AP_COMMON

Agent policies common attributes

Table 27. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique policy identifier

policy_type

INTEGER

NOT NULL

βˆ…

Policy type

version

INTEGER

NOT NULL

βˆ…

Policy version

flags

INTEGER

NOT NULL

βˆ…

Common policy flags

deploy_filter

TEXT

NOT NULL

βˆ…

NXSL auto apply filter

Table 28. Indexes

Name

Type

Fields

ap_common_pkey

UNIQUE

id

AP_CONFIG_FILES

Agent policies configuration files

Table 29. Columns

Name

Type

State

Default

Description

πŸ”‘policy_id

INTEGER

NOT NULL

βˆ…

Unique policy identifier from AP_COMMON

file_content

TEXT

NULL

βˆ…

Policy file content

Table 30. Indexes

Name

Type

Fields

ap_config_files_pkey

UNIQUE

policy_id

AP_LOG_PARSER

Agent policies log parser files

Table 31. Columns

Name

Type

State

Default

Description

πŸ”‘policy_id

INTEGER

NOT NULL

βˆ…

Unique policy identifier from AP_COMMON

file_content

TEXT

NULL

βˆ…

Log parser policy file content

Table 32. Indexes

Name

Type

Fields

ap_log_parser_pkey

UNIQUE

policy_id

AUDIT_LOG

Log of all user actions.

Table 33. Columns

Name

Type

State

Default

Description

πŸ”‘record_id

INTEGER

NOT NULL

βˆ…

Unique record identifier.

timestamp

INTEGER

NOT NULL

βˆ…

Unix timestamp.

subsystem

VARCHAR(32)

NOT NULL

βˆ…

System component name.

success

INTEGER

NOT NULL

βˆ…

Success indicator.

user_id

INTEGER

NOT NULL

βˆ…

ID of the user performed logged action. Reference to USERS.

workstation

VARCHAR(63)

NOT NULL

βˆ…

IP of the user’s workstation.

session_id

INTEGER

NOT NULL

βˆ…

User’s session id.

object_id

INTEGER

NOT NULL

βˆ…

Target object id which was involved in the logged action.

message

TEXT

NULL

βˆ…

Audit record text.

old_value

TEXT

NULL

βˆ…

Old value. Object is saved in json format

new_value

TEXT

NULL

βˆ…

New value. Object is saved in json format

value_diff

TEXT

NULL

βˆ…

Diff from old and new value. Object data is represented in json format

Table 34. Indexes

Name

Type

Fields

audit_log_pkey

UNIQUE

record_id

BUSINESS_SERVICES

Business services for defining SLA.

Table 35. Columns

Name

Type

State

Default

Description

πŸ”‘service_id

INTEGER

NOT NULL

βˆ…

Unique identifier from OBJECT_PROPERTIES

Table 36. Indexes

Name

Type

Fields

business_services_pkey

UNIQUE

service_id

CERTIFICTE_ACTION_LOG

Certificate activity log

Table 37. Columns

Name

Type

State

Default

Description

πŸ”‘record_id

INTEGER

NOT NULL

βˆ…

Record primary key

timestamp

INTEGER

NOT NULL

βˆ…

Action timestamp

operation

INTEGER

NOT NULL

βˆ…

Operation:

  • 1 - ISSUE_CERTIFICATE

  • 2 - REVOKE_CERTIFICATE

user_id

INTEGER

NOT NULL

βˆ…

User id form USERS

node_id

INTEGER

NOT NULL

βˆ…

Node id from NODES

node_guid

VARCHAR(36)

NULL

βˆ…

Node guid

cert_type

INTEGER

NOT NULL

βˆ…

Type of certificate:

  • 0 - CERT_TYPE_TRUSTED_CA

  • 1 - CERT_TYPE_USER

  • 2 - CERT_TYPE_AGENT

  • 3 - CERT_TYPE_SERVER

subject

VARCHAR(36)

NULL

βˆ…

Subject

serial

VARCHAR(36)

NULL

βˆ…

Serial

Table 38. Indexes

Name

Type

Fields

certificate_action_log_pkey

UNIQUE

record_id

CERTIFICATES

Storage for x509 certificates used for authentication.

Table 39. Columns

Name

Type

State

Default

Description

πŸ”‘cert_id

INTEGER

NOT NULL

βˆ…

Unique identifier

cert_type

INTEGER

NOT NULL

βˆ…

Type of the certificate. Known values:

  • 0 - Trusted CA

  • 1 - User certificate

  • 2 - Agent certificate

  • 3 - Server certificate

cert_data

TEXT

NOT NULL

βˆ…

PEM-encoded body of the certificate.

subject

TEXT

NOT NULL

βˆ…

Certificate subject.

comments

TEXT

NOT NULL

βˆ…

Certificate comments added by administrator.

Table 40. Indexes

Name

Type

Fields

certificates_pkey

UNIQUE

cert_id

CHASSIS

Chassis

Table 41. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Chassis id from OBJECT_PROPERTIES

controller_id

INTEGER

NOT NULL

βˆ…

Id of node object providing management capabilities for this chassis

flags

INTEGER

NOT NULL

βˆ…

Chassis options as bit flags

rack_id

INTEGER

NOT NULL

βˆ…

Related rack object ID

rack_image_front

VARCHAR(36)

NULL

βˆ…

Image to be used in front rack view

rack_position

INTEGER

NOT NULL

βˆ…

Position in rack (in rack units)

rack_height

INTEGER

NOT NULL

βˆ…

Height in rack (in rack units)

rack_orientation

INTEGER

NOT NULL

βˆ…

Rack orientation type:

  • 0 - FILL

  • 1 - FRONT

  • 2 - REAR

rack_image_rear

VARCHAR(36)

NOT NULL

βˆ…

Image GUID to be used in rear rack view

Table 42. Indexes

Name

Type

Fields

chassis_pkey

UNIQUE

id

CLUSTER_MEMBERS

Cluster members

Table 43. Columns

Name

Type

State

Default

Description

πŸ”‘cluster_id

INTEGER

NOT NULL

βˆ…

Cluster ID. Reference to CLUSTERS.

πŸ”‘node_id

INTEGER

NOT NULL

βˆ…

Node ID. Reference to NODES.

Table 44. Indexes

Name

Type

Fields

cluster_members_pkey

UNIQUE

cluster_id,node_id

CLUSTER_RESOURCES

Cluster resources which can migrate between nodes. Currently only VIP migration is supported.

Table 45. Columns

Name

Type

State

Default

Description

πŸ”‘cluster_id

INTEGER

NOT NULL

βˆ…

ID of the cluster. Reference to CLUSTERS.

πŸ”‘resource_id

INTEGER

NOT NULL

βˆ…

Unique identifier

resource_name

VARCHAR(255)

NULL

βˆ…

Name of the resource.

ip_addr

VARCHAR(48)

NOT NULL

βˆ…

IP address of the resource (VIP).

current_owner

INTEGER

NOT NULL

βˆ…

Node which currently owns the resource. Reference to NODES.

Table 46. Indexes

Name

Type

Fields

cluster_resources_pkey

UNIQUE

cluster_id,resource_id

CLUSTER_SYNC_SUBNETS

Cluster subnets used for interconnect.

Table 47. Columns

Name

Type

State

Default

Description

πŸ”‘cluster_id

INTEGER

NOT NULL

βˆ…

Cluster ID. Reference to CLUSTERS.

πŸ”‘subnet_addr

VARCHAR(48)

NOT NULL

βˆ…

Network address.

subnet_mask

INTEGER

NOT NULL

βˆ…

Network mask as number of bits (CIDR).

Table 48. Indexes

Name

Type

Fields

cluster_sync_subnets_pkey

UNIQUE

cluster_id,subnet_addr

CLUSTERS

Information specific for Cluster objects.

Table 49. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier.

cluster_type

INTEGER

NOT NULL

βˆ…

Reserved for future use.

zone_guid

INTEGER

NOT NULL

βˆ…

Zone GUID. Reference to ZONES.

Table 50. Indexes

Name

Type

Fields

clusters_pkey

UNIQUE

id

COND_DCI_MAP

Mapping of the conditions to corresponding data collection items.

Table 51. Columns

Name

Type

State

Default

Description

πŸ”‘condition_id

INTEGER

NOT NULL

βˆ…

Condition ID. Reference to CONDITIONS.

πŸ”‘sequence_number

INTEGER

NOT NULL

βˆ…

Sequence number.

dci_id

INTEGER

NOT NULL

βˆ…

ID of the DCI. Reference to ITEMS.

node_id

INTEGER

NOT NULL

βˆ…

ID of the node. Reference to NODES.

dci_func

INTEGER

NOT NULL

βˆ…

DCI function to use. Known values:

  • 0 - Last value

  • 1 - Average value

  • 2 - Mean deviation

  • 3 - Difference with previous value

  • 4 - Data collection error

  • 5 - Sum of values

  • 6 - Run NXSL script

num_polls

INTEGER

NOT NULL

βˆ…

Number of values for dci_func to process.

Table 52. Indexes

Name

Type

Fields

cond_dci_map_pkey

UNIQUE

condition_id,sequence_number

CONDITIONS

Conditions definition table.

Table 53. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier.

activation_event

INTEGER

NOT NULL

βˆ…

Event code of the activation event. Reference to EVENT_CFG.

deactivation_event

INTEGER

NOT NULL

βˆ…

Event code of the deactivation event. Reference to EVENT_CFG.

source_object

INTEGER

NOT NULL

βˆ…

Source object for generating events. Reference to NODES or CLUSTERS.

active_status

INTEGER

NOT NULL

βˆ…

Condition active status:

  • 0 - STATUS_NORMAL

  • 1 - STATUS_WARNING

  • 2 - STATUS_MINOR

  • 3 - STATUS_MAJOR

  • 4 - STATUS_CRITICAL

  • 5 - STATUS_UNKNOWN

  • 6 - STATUS_UNMANAGED

  • 7 - STATUS_DISABLED

  • 8 - STATUS_TESTING

inactive_status

INTEGER

NOT NULL

βˆ…

Condition inactive status:

  • 0 - STATUS_NORMAL

  • 1 - STATUS_WARNING

  • 2 - STATUS_MINOR

  • 3 - STATUS_MAJOR

  • 4 - STATUS_CRITICAL

  • 5 - STATUS_UNKNOWN

  • 6 - STATUS_UNMANAGED

  • 7 - STATUS_DISABLED

  • 8 - STATUS_TESTING

script

TEXT

NOT NULL

βˆ…

NXSL script for activating condition.

Table 54. Indexes

Name

Type

Fields

conditions_pkey

UNIQUE

id

CONFIG_CLOB

System configuration table for large data elements

Table 55. Columns

Name

Type

State

Default

Description

πŸ”‘var_name

VARCHAR(63)

NOT NULL

βˆ…

Parameter name

var_value

TEXT

NULL

βˆ…

Value

Table 56. Indexes

Name

Type

Fields

config_clob_pkey

UNIQUE

var_name

CONFIG_REPOSITORIES

Repository configuration for templates market.

Table 57. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier.

url

VARCHAR(1023)

NOT NULL

βˆ…

Repository URL.

auth_token

VARCHAR(63)

NULL

βˆ…

Repository authentication token.

description

VARCHAR(1023)

NULL

βˆ…

Repository description.

Table 58. Indexes

Name

Type

Fields

config_repositories_pkey

UNIQUE

id

CONFIG_VALUES

Possible values for system configuration parameters. Used by the GUI only.

Table 59. Columns

Name

Type

State

Default

Description

πŸ”‘var_name

VARCHAR(63)

NOT NULL

βˆ…

Parameter name. Reference to CONFIG.

πŸ”‘var_value

VARCHAR(15)

NOT NULL

βˆ…

Parameter value

var_description

VARCHAR(255)

NULL

βˆ…

Parameter description

Table 60. Indexes

Name

Type

Fields

config_values_pkey

UNIQUE

var_name,var_value

CONFIG

Server configuration.

Table 61. Columns

Name

Type

State

Default

Description

πŸ”‘var_name

VARCHAR(63)

NOT NULL

βˆ…

Parameter name

var_value

VARCHAR(2000)

NULL

βˆ…

Value

is_visible

INTEGER

NOT NULL

1

GUI visibility indicator.

need_server_restart

INTEGER

NOT NULL

0

Change take effect after server restart.

data_type

CHAR(1)

NOT NULL

S

Type of the attribute. Known values:

  • S – String

  • I – Integer

  • B – Boolean

  • C – Choice (Drop-down list displayed in UI)

  • H - Color (Color picker displayed in UI)

is_public

CHAR(1)

NOT NULL

N

If set to non-zero, configuration parameter is visible to all users, even for those without granted access to server configuration.

description

VARCHAR(450)

NULL

βˆ…

Configuration parameter’s description shown in the UI.

Table 62. Indexes

Name

Type

Fields

config_pkey

UNIQUE

var_name

CONTAINER_MEMBERS

Parent-child relations between containers and objects inside them.

Table 63. Columns

Name

Type

State

Default

Description

πŸ”‘container_id

INTEGER

NOT NULL

βˆ…

Container ID. Reference to OBJECT_CONTAINERS.

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Child object ID. Reference to any object which can be placed into container (NODES, CLUSTERS, OBJECT_CONTAINERS).

Table 64. Indexes

Name

Type

Fields

container_members_pkey

UNIQUE

container_id,object_id

COUNTRY_CODES

List of country codes

Table 65. Columns

Name

Type

State

Default

Description

πŸ”‘numeric_code

CHAR(3)

NOT NULL

βˆ…

Numeric ISO code

alpha_code

CHAR(2)

NOT NULL

βˆ…

Alphabetical 2 character ISO code

alpha3_code

CHAR(3)

NOT NULL

βˆ…

Alphabetical 3 character ISO code

name

VARCHAR(127)

NOT NULL

βˆ…

Country name

Table 66. Indexes

Name

Type

Fields

country_codes_pkey

UNIQUE

numeric_code

CURRENCY_CODES

List of currency codes

Table 67. Columns

Name

Type

State

Default

Description

πŸ”‘numeric_code

CHAR(3)

NOT NULL

βˆ…

Numeric ISO code

alpha_code

CHAR(3)

NOT NULL

βˆ…

Alphabetical ISO code

description

VARCHAR(127)

NOT NULL

βˆ…

Description

exponent

INTEGER

NOT NULL

βˆ…

Exponent for minor units

Table 68. Indexes

Name

Type

Fields

currency_codes_pkey

UNIQUE

numeric_code

DASHBOARD_ASSOCIATIONS

Associations between dashboards and other objects

Table 69. Columns

Name

Type

State

Default

Description

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Object id from OBJECT_PROPERTIES

πŸ”‘dashboard_id

INTEGER

NOT NULL

βˆ…

Dashboard id from DASHBOARDS

Table 70. Indexes

Name

Type

Fields

dashboard_associations_pkey

UNIQUE

object_id,dashboard_id

DASHBOARD_ELEMENTS

Widgets and layout configuration of each dashboard.

Table 71. Columns

Name

Type

State

Default

Description

πŸ”‘dashboard_id

INTEGER

NOT NULL

βˆ…

ID of the dashboard. Reference to DASHBOARDS.

πŸ”‘element_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

element_type

INTEGER

NOT NULL

βˆ…

Type of the element. Known values:

  • 0 – Label

  • 1 – Line Chart

  • 2 – Bar Chart

  • 3 – Pie Chart

  • 4 – Tube Chart

  • 5 – Status Chart

  • 6 – Status Indicator

  • 7 – Embeded Dashboard

  • 8 – Network Map

  • 9 – Custom

  • 10 – Geo map

  • 11 – Alarm Viewer

  • 12 – Availability Chart

  • 13 – Dial Chart

  • 14 – Web Page

  • 15 – Table Bar Chart

  • 16 – Table Pie Chart

  • 17 – Table Tube Chart

  • 18 – Separator

  • 19 – Table Last Value

  • 20 – Status Map

  • 21 – DCI Summary Table

  • 22 – Syslog Monitor

  • 23 – SNMP Trap Monitor

  • 24 – Event Monitor

element_data

TEXT

NULL

βˆ…

Widget configuration (data sources, etc.). Format is internal to a widget.

layout_data

TEXT

NULL

βˆ…

Widget layout details.

Table 72. Indexes

Name

Type

Fields

dashboard_elements_pkey

UNIQUE

dashboard_id,element_id

DASHBOARDS

List of all dashboards.

Table 73. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier.

num_columns

INTEGER

NOT NULL

βˆ…

Number of columns in in the dashboard.

options

INTEGER

NOT NULL

βˆ…

Bitmask of additional dashboard options. Known values:

  • 0x0001 – All columns should have equal width

Table 74. Indexes

Name

Type

Fields

dashboards_pkey

UNIQUE

id

DC_TABLE_COLUMNS

Data collection configuration for table items – column configuration.

Table 75. Columns

Name

Type

State

Default

Description

πŸ”‘table_id

INTEGER

NOT NULL

βˆ…

Reference to item_id in DC_TABLES.

sequence_number

INTEGER

NOT NULL

βˆ…

Column number used for sorting.

πŸ”‘column_name

VARCHAR(63)

NOT NULL

βˆ…

Name of the column as read from the agent.

snmp_oid

VARCHAR(1023)

NULL

βˆ…

SNMP OID (used only if table source is SNMP).

flags

INTEGER

NOT NULL

βˆ…

Bitmark of column flags. Known values:

  • 0x0000 – Type: Integer

  • 0x0001 – Type: Unsigned Integer

  • 0x0002 – Type: Int64

  • 0x0003 – Type: Unsigned Int64

  • 0x0004 – Type: String

  • 0x0005 – Type: Float

  • 0x0010 – Aggregate: Average

  • 0x0020 – Aggregate: Min

  • 0x0030 – Aggregate: Max

  • 0x0100 – This column is instance (key) column

  • 0x0200 – This column is instance label column

display_name

VARCHAR(255)

NULL

βˆ…

Column name to be shown to user.

Table 76. Indexes

Name

Type

Fields

dc_table_columns_pkey

UNIQUE

table_id,column_name

DC_TABLES

Data collection configuration for table items.

Table 77. Columns

Name

Type

State

Default

Description

πŸ”‘item_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

node_id

INTEGER

NOT NULL

βˆ…

Object where DCI is configured. Reference to NODES or CLUSTERS.

template_id

INTEGER

NOT NULL

βˆ…

ID of the source template. If item was created directly on the node, value will be 0. Reference to TEMPLATES.

template_item_id

INTEGER

NOT NULL

βˆ…

ID of the DCI in the template. If item was created directly on the node, value will be 0. Reference to TEMPLATES.

guid

VARCHAR(36)

NOT NULL

βˆ…

Record GUID.

name

VARCHAR(1023)

NULL

βˆ…

Name of the parameter. Depending on the source, it can be agent’s parameter, SNMP OID, Script name, etc.

description

VARCHAR(255)

NULL

βˆ…

Human readable description of the item.

flags

INTEGER

NOT NULL

βˆ…

Data collection table flags:

  • DCF_ADVANCED_SCHEDULE 0x0001

  • DCF_ALL_THRESHOLDS 0x0002

  • DCF_RAW_VALUE_OCTET_STRING 0x0004

  • DCF_SHOW_ON_OBJECT_TOOLTIP 0x0008

  • DCF_AGGREGATE_FUNCTION_MASK 0x0070

  • DCF_AGGREGATE_ON_CLUSTER 0x0080

  • DCF_TRANSFORM_AGGREGATED 0x0100

  • DCF_NO_STORAGE 0x0200

  • DCF_CALCULATE_NODE_STATUS 0x0400

  • DCF_SHOW_IN_OBJECT_OVERVIEW 0x0800

  • DCF_CACHE_MODE_MASK 0x3000

  • DCF_AGGREGATE_WITH_ERRORS 0x4000

source

INTEGER

NOT NULL

βˆ…

Source node. If this value is non-zero, server will query data from this node instead of the node specified by node_id. Reference to NODES.

snmp_port

INTEGER

NOT NULL

βˆ…

SNMP port.

polling_interval

INTEGER

NOT NULL

βˆ…

Polling interval in seconds.

retention_time

INTEGER

NOT NULL

βˆ…

Retention time in days.

status

INTEGER

NOT NULL

βˆ…

Status of the DCI. Known values:

  • 0 – Active

  • 1 – Disabled

  • 2 – Not Supported

system_tag

VARCHAR(255)

NULL

βˆ…

System tag used by different system modules to save module information

resource_id

INTEGER

NOT NULL

βˆ…

Cluster resource id from CLUSTER_RESOURCES

proxy_node

INTEGER

NOT NULL

βˆ…

ID of the proxy node. Reference to NODES.

perftab_settings

TEXT

NULL

βˆ…

Data collection table XML configuration for Performance tab

transformation_script

TEXT

NULL

βˆ…

NXSL transformation script

comments

TEXT

NULL

βˆ…

Data collection table comment

instance

VARCHAR(255)

NULL

βˆ…

Instance

instd_method

INTEGER

NOT NULL

βˆ…

Method of instance discovery

  • 0 – IDM_NONE

  • 1 – IDM_AGENT_LIST

  • 2 – IDM_AGENT_TABLE

  • 3 – IDM_SNMP_WALK_VALUES

  • 4 – IDM_SNMP_WALK_OIDS

  • 5 – IDM_SCRIPT

instd_data

VARCHAR(255)

NULL

βˆ…

Data for instance discovery (Srcipt name, Agent list…​)

instd_filter

TEXT

NULL

βˆ…

NXSL instance discovery filter

instance_retention_time

INTEGER

NOT NULL

βˆ…

Retention time for deleted instances from instance discovery

grace_period_start

INTEGER

NOT NULL

βˆ…

Start for grade period for deleted instance

Table 78. Indexes

Name

Type

Fields

idx_dc_tables_node_id

NORMAL

node_id

dc_tables_pkey

UNIQUE

item_id

DCI_ACCESS

Access rights for dci

Table 79. Columns

Name

Type

State

Default

Description

πŸ”‘dci_id

INTEGER

NOT NULL

βˆ…

DCI ID. Reference to either ITEMS or DC_TABLES.

πŸ”‘user_id

INTEGER

NOT NULL

βˆ…

User id from USERS

Table 80. Indexes

Name

Type

Fields

dci_access_pkey

UNIQUE

dci_id,user_id

DCI_SCHEDULES

Advanced schedules for DCI.

Table 81. Columns

Name

Type

State

Default

Description

πŸ”‘schedule_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

πŸ”‘item_id

INTEGER

NOT NULL

βˆ…

DCI ID. Reference to either ITEMS or DC_TABLES.

schedule

VARCHAR(255)

NULL

βˆ…

Cron-like schedule definition.

Table 82. Indexes

Name

Type

Fields

dci_schedules_pkey

UNIQUE

item_id,schedule_id

DCI_SUMMARY_TABLES

Configuration of DCI summary tables.

Table 83. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier.

guid

VARCHAR(36)

NOT NULL

βˆ…

Summary Table GUID.

menu_path

VARCHAR(255)

NULL

βˆ…

Path of the element in "Summary Tables" menu.

title

VARCHAR(127)

NULL

βˆ…

Title of the summary table.

node_filter

TEXT

NULL

βˆ…

NXSL script to filter out unrequired nodes.

flags

INTEGER

NOT NULL

βˆ…

Flags:

  • 0x0001 - MULTI_INSTANCE

  • 0x0002 - TABLE_DCI_SOURCE

columns

VARCHAR(255)

NULL

βˆ…

Columns configuration.

table_dci_name

TEXT

NULL

βˆ…

Name of the summary table.

Table 84. Indexes

Name

Type

Fields

dci_summary_tables_pkey

UNIQUE

id

DCT_THREASHOLD_INSTANCES

Table stores matched instances by table threashold

Table 85. Columns

Name

Type

State

Default

Description

πŸ”‘threshold_id

INTEGER

NOT NULL

βˆ…

Threshold id from DCT_THRESHOLDS

instance

VARCHAR(255)

NOT NULL

βˆ…

Matched threshold instance.

match_count

INTEGER

NOT NULL

βˆ…

Number of times this threshold, instance couple were matched

is_active

CHAR(1)

NOT NULL

βˆ…

Defines if this threshold, instance couple is active

tt_row_number

INTEGER

NOT NULL

βˆ…

Row number

maint_copy

CHAR(1)

NOT NULL

βˆ…

Flag that states that threshold happened before maintenance

Table 86. Indexes

Name

Type

Fields

dct_threashold_instances_pkey

UNIQUE

threshold_id,instance,maint_copy

DCT_COLUMN_NAMES

Data collection configuration for table items - column names.

Table 87. Columns

Name

Type

State

Default

Description

πŸ”‘column_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

column_name

VARCHAR(63)

NOT NULL

βˆ…

Name of the column.

Table 88. Indexes

Name

Type

Fields

dct_column_names_pkey

UNIQUE

column_id

DCT_NODE_MAP

Mapping between nodes and applied templates with table DCI.

Table 89. Columns

Name

Type

State

Default

Description

πŸ”‘template_id

INTEGER

NOT NULL

βˆ…

Templade ID. Reference to TEMPLATES.

πŸ”‘node_id

INTEGER

NOT NULL

βˆ…

Target node ID. Reference to NODES or CLUSTERS.

Table 90. Indexes

Name

Type

Fields

dct_node_map_pkey

UNIQUE

template_id,node_id

DCT_THRESHOLD_CONDITIONS

Table threshold conditions

Table 91. Columns

Name

Type

State

Default

Description

πŸ”‘threshold_id

INTEGER

NOT NULL

βˆ…

Threshold id form DCT_THREASHOLD_INSTANCES

πŸ”‘group_id

INTEGER

NOT NULL

βˆ…

Group id

πŸ”‘sequence_number

INTEGER

NOT NULL

βˆ…

Sequence id

column_name

VARCHAR(63)

NULL

βˆ…

Column name

check_operation

INTEGER

NOT NULL

βˆ…

Check operation:

  • 0 - OP_LE

  • 1 - OP_LE_EQ

  • 2 - OP_EQ

  • 3 - OP_GT_EQ

  • 4 - OP_GT

  • 5 - OP_NE

  • 6 - OP_LIKE

  • 7 - OP_NOTLIKE

check_value

VARCHAR(255)

NULL

βˆ…

Check value

Table 92. Indexes

Name

Type

Fields

dct_threshold_conditions_pkey

UNIQUE

threshold_id,group_id,sequence_number

DCT_THRESHOLDS

Table threshold configuration

Table 93. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique threshold identifier

table_id

INTEGER

NOT NULL

βˆ…

Item id from DC_TABLES

sequence_number

INTEGER

NOT NULL

βˆ…

Threashold proccessing sequence number

activation_event

INTEGER

NOT NULL

βˆ…

Event code of activation event from EVENT_CFG

deactivation_event

INTEGER

NOT NULL

βˆ…

Event code of deactivation event from EVENT_CFG

sample_count

INTEGER

NOT NULL

βˆ…

Required sample count for state change

Table 94. Indexes

Name

Type

Fields

dct_thresholds_pkey

UNIQUE

id

EVENT_CFG

Event templates

Table 95. Columns

Name

Type

State

Default

Description

πŸ”‘event_code

INTEGER

NOT NULL

βˆ…

Event code (unique within system)

event_name

VARCHAR(63)

NOT NULL

βˆ…

Event name

guid

VARCHAR(36)

NOT NULL

βˆ…

Event template GUID

severity

INTEGER

NOT NULL

βˆ…

Severity

flags

INTEGER

NOT NULL

βˆ…

Flags

message

VARCHAR(2000)

NULL

βˆ…

Message template

description

TEXT

NULL

βˆ…

Event description

Table 96. Indexes

Name

Type

Fields

event_cfg_pkey

UNIQUE

event_code

EVENT_GROUP_MEMBERS

Reserved for future use.

Table 97. Columns

Name

Type

State

Default

Description

πŸ”‘group_id

INTEGER

NOT NULL

βˆ…

πŸ”‘event_code

INTEGER

NOT NULL

βˆ…

Table 98. Indexes

Name

Type

Fields

event_group_members_pkey

UNIQUE

group_id,event_code

EVENT_GROUPS

Reserved for future use.

Table 99. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

name

VARCHAR(63)

NOT NULL

βˆ…

description

VARCHAR(255)

NOT NULL

βˆ…

range_start

INTEGER

NOT NULL

βˆ…

range_end

INTEGER

NOT NULL

βˆ…

Table 100. Indexes

Name

Type

Fields

event_groups_pkey

UNIQUE

id

EVENT_LOG

All events which was emmited in the system. Table is cleaned up automatically by the housekeeper.

Table 101. Columns

Name

Type

State

Default

Description

πŸ”‘event_id

BIGINT

NOT NULL

βˆ…

Unique identifier.

event_code

INTEGER

NOT NULL

βˆ…

Event code. Reference to EVENT_CFG.

event_timestamp

INTEGER

NOT NULL

βˆ…

Unix time stamp of the event.

event_source

INTEGER

NOT NULL

βˆ…

Source object which originated evenent.

dci_id

INTEGER

NOT NULL

βˆ…

Non-zero ID of the DCI related to this event. If event is unrelated to any DCI, value is 0.

event_severity

INTEGER

NOT NULL

βˆ…

Event severity at the moment of insertion into log.

event_message

VARCHAR(2000)

NULL

βˆ…

Event message.

root_event_id

BIGINT

NOT NULL

βˆ…

If event was correlated, this field contains root event which cause further events to be emmited.

user_tag

VARCHAR(63)

NULL

βˆ…

zone_uin

INTEGER

NULL

βˆ…

Zone unique identification number form ZONES

raw_data

TEXT

NULL

βˆ…

Event raw data

Table 102. Indexes

Name

Type

Fields

idx_event_log_root_id

NORMAL

root_event_id

idx_event_log_source

NORMAL

event_source

idx_event_log_event_timestamp

NORMAL

event_timestamp

event_log_pkey

UNIQUE

event_id

EVENT_POLICY

Event processing policy.

Table 103. Columns

Name

Type

State

Default

Description

πŸ”‘rule_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

rule_guid

VARCHAR(36)

NOT NULL

βˆ…

GUID of the record.

flags

INTEGER

NOT NULL

βˆ…

Rule flags.

comments

TEXT

NULL

βˆ…

Comments as show in rule editor.

script

TEXT

NULL

βˆ…

NXSL filtering script. Should return True for rule to execute.

alarm_message

VARCHAR(2000)

NULL

βˆ…

Message for creating alarm based on the event.

alarm_severity

INTEGER

NOT NULL

βˆ…

Severity for created alarm.

alarm_key

VARCHAR(255)

NULL

βˆ…

alarm_timeout

INTEGER

NOT NULL

βˆ…

alarm_timeout_event

INTEGER

NOT NULL

βˆ…

Table 104. Indexes

Name

Type

Fields

event_policy_pkey

UNIQUE

rule_id

GRAPH_ACL

Access control table for saved graphs.

Table 105. Columns

Name

Type

State

Default

Description

πŸ”‘graph_id

INTEGER

NOT NULL

βˆ…

Graph ID. Reference to GRAPHS.

πŸ”‘user_id

INTEGER

NOT NULL

βˆ…

User ID. Reference to USERS or USER_GROUPS.

user_rights

INTEGER

NOT NULL

βˆ…

Bitmaks of effective permissions. Known values:

  • 0x00000001 – Read

  • 0x00000002 – Modify

  • 0x00000008 – Delete

Table 106. Indexes

Name

Type

Fields

graph_acl_pkey

UNIQUE

graph_id,user_id

GRAPHS

Saved graphs.

Table 107. Columns

Name

Type

State

Default

Description

πŸ”‘graph_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

owner_id

INTEGER

NOT NULL

βˆ…

Object owner. Reference to USERS.

flags

INTEGER

NOT NULL

βˆ…

name

VARCHAR(255)

NOT NULL

βˆ…

Name of the graph.

config

TEXT

NULL

βˆ…

XML-based configuration of the graph.

filters

TEXT

NULL

βˆ…

Table 108. Indexes

Name

Type

Fields

graphs_pkey

UNIQUE

graph_id

IDATA_<NODE_ID>

Contains historical values for single-value DCIs for the node. Table name is dynamic, <NODE_ID> is replaced by actuall node id (e.g. "IDATA_100"). The table is populated only if single table performance data is disabled.

Table 109. Columns

Name

Type

State

Default

Description

πŸ”‘item_id

INTEGER

NOT NULL

βˆ…

Item id from ITEMS

πŸ”‘idata_timestamp

INTEGER

NOT NULL

βˆ…

Unix time stamp

idata_value

VARCHAR(255)

NULL

βˆ…

Collected value.

Table 110. Indexes

Name

Type

Fields

idx_idata_<NODE_ID>_id_timestamp

NORMAL

item_id,idata_timestamp

IDATA

Contains historical values for single-value DCIs for the node. The table is populated only if single table performance data is enabled.

Table 111. Columns

Name

Type

State

Default

Description

πŸ”‘node_id

INTEGER

NOT NULL

βˆ…

Object id from OBJECT_PROPERTIES

πŸ”‘item_id

INTEGER

NOT NULL

βˆ…

Item id from ITEMS

πŸ”‘idata_timestamp

INTEGER

NOT NULL

βˆ…

Unix time stamp for collected value

idata_value

VARCHAR(255)

NULL

βˆ…

Collected value.

raw_value

VARCHAR(255)

NULL

βˆ…

Raw value. Not used in 2.2.

Table 112. Indexes

Name

Type

Fields

idata_key

NORMAL

node_id,item_id,idata_timestamp

IMAGES

Meta-data for image library.

Table 113. Columns

Name

Type

State

Default

Description

πŸ”‘guid

VARCHAR(36)

NOT NULL

βˆ…

Image GUID.

name

VARCHAR(63)

NOT NULL

βˆ…

Name of the image.

category

VARCHAR(63)

NOT NULL

βˆ…

Image category.

mimetype

VARCHAR(32)

NOT NULL

βˆ…

MIME-type of the image.

protected

INTEGER

NULL

0

Read-only marker for bundled images.

Table 114. Indexes

Name

Type

Fields

images_name_category_key

UNIQUE

name,category

images_pkey

UNIQUE

guid

INTERFACE_ADDRESS_LIST

Interface IP addresses

Table 115. Columns

Name

Type

State

Default

Description

πŸ”‘iface_id

INTEGER

NOT NULL

βˆ…

Interface id form INTERFACES

πŸ”‘ip_addr

VARCHAR(48)

NOT NULL

βˆ…

IP addess

ip_netmask

INTEGER

NOT NULL

βˆ…

Network mask

Table 116. Indexes

Name

Type

Fields

interface_address_list_pkey

UNIQUE

iface_id,ip_addr

INTERFACE_VLAN_LIST

Vlan to interface connection

Table 117. Columns

Name

Type

State

Default

Description

πŸ”‘iface_id

INTEGER

NOT NULL

βˆ…

Interface id from INTERFACES

πŸ”‘vlan_id

INTEGER

NOT NULL

βˆ…

Vlan id

Table 118. Indexes

Name

Type

Fields

interface_vlan_list_pkey

UNIQUE

iface_id,vlan_id

INTERFACES

Interface information

Table 119. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Record primary key

node_id

INTEGER

NOT NULL

βˆ…

Node id from NODES

flags

INTEGER

NOT NULL

βˆ…

Interface flags:

  • IF_SYNTHETIC_MASK 0x01

  • IF_PHYSICAL_PORT 0x02

  • IF_EXCLUDE_FROM_TOPOLOGY 0x04

  • IF_LOOPBACK 0x08

  • IF_CREATED_MANUALLY 0x10

  • IF_PEER_REFLECTION 0x20 /* topology information obtained by reflection */

  • IF_EXPECTED_STATE_MASK 0x30000000 /* 2-bit field holding expected interface state */

if_type

INTEGER

NOT NULL

βˆ…

If type. (SNMP standard values)

if_index

INTEGER

NOT NULL

βˆ…

Index of interface

mtu

INTEGER

NOT NULL

βˆ…

MTU (bytes)

speed

BIGINT

NOT NULL

βˆ…

Speed (bps)

bridge_port

INTEGER

NOT NULL

βˆ…

Bridge port number

phy_slot

INTEGER

NOT NULL

βˆ…

Physical slot number

phy_port

INTEGER

NOT NULL

βˆ…

Physical port number

peer_node_id

INTEGER

NOT NULL

βˆ…

Peer node id from NODES

peer_if_id

INTEGER

NOT NULL

βˆ…

Peer interface id from INTERFACES

peer_proto

INTEGER

NOT NULL

βˆ…

Discovery protocol used for peer discovery

mac_addr

VARCHAR(12)

NOT NULL

βˆ…

MAC address

required_polls

INTEGER

NOT NULL

βˆ…

Number of polls for status change

admin_state

INTEGER

NOT NULL

βˆ…

Interface administrative states:

  • 0 - IF_ADMIN_STATE_UNKNOWN

  • 1 - IF_ADMIN_STATE_UP

  • 2 - IF_ADMIN_STATE_DOWN

  • 3 - IF_ADMIN_STATE_TESTING

oper_state

INTEGER

NOT NULL

βˆ…

Interface operational states:

  • 0 - IF_OPER_STATE_UNKNOWN

  • 1 - IF_OPER_STATE_UP

  • 2 - IF_OPER_STATE_DOWN

  • 3 - IF_OPER_STATE_TESTING

  • 4 - IF_OPER_STATE_DORMANT

  • 5 - IF_OPER_STATE_NOT_PRESENT

dot1x_pae_state

INTEGER

NOT NULL

βˆ…

802.1x PAE state

dot1x_backend_state

INTEGER

NOT NULL

βˆ…

802.1x backend state

description

VARCHAR(255)

NULL

βˆ…

Interface description

alias

VARCHAR(255)

NULL

βˆ…

Interface alias

iftable_suffix

VARCHAR(127)

NULL

βˆ…

SNMP OID suffix in ifTable

parent_iface

INTEGER

NOT NULL

βˆ…

Interface id from INTERFACES

Table 120. Indexes

Name

Type

Fields

interfaces_pkey

UNIQUE

id

ITEMS

Data collection configuration for signle-value items.

Table 121. Columns

Name

Type

State

Default

Description

πŸ”‘item_id

INTEGER

NOT NULL

βˆ…

Unique identifier.

node_id

INTEGER

NOT NULL

βˆ…

Object where DCI is configured. Reference to NODES or CLUSTERS.

template_id

INTEGER

NOT NULL

βˆ…

ID of the source template. If item was created directly on the node, value will be 0. Reference to TEMPLATES.

template_item_id

INTEGER

NOT NULL

βˆ…

ID of the DCI in the template. If item was created directly on the node, value will be 0. Reference to TEMPLATES.

guid

VARCHAR(36)

NOT NULL

βˆ…

Record GUID.

name

VARCHAR(1023)

NULL

βˆ…

Name of the parameter. Depending on the source, it can be agent’s parameter, SNMP OID, Script name, etc.

description

VARCHAR(255)

NULL

βˆ…

Human readable description of the item.

flags

INTEGER

NOT NULL

βˆ…

Data collection item flags:

  • DCF_ADVANCED_SCHEDULE 0x0001

  • DCF_ALL_THRESHOLDS 0x0002

  • DCF_RAW_VALUE_OCTET_STRING 0x0004

  • DCF_SHOW_ON_OBJECT_TOOLTIP 0x0008

  • DCF_AGGREGATE_FUNCTION_MASK 0x0070

  • DCF_AGGREGATE_ON_CLUSTER 0x0080

  • DCF_TRANSFORM_AGGREGATED 0x0100

  • DCF_NO_STORAGE 0x0200

  • DCF_CALCULATE_NODE_STATUS 0x0400

  • DCF_SHOW_IN_OBJECT_OVERVIEW 0x0800

  • DCF_CACHE_MODE_MASK 0x3000

  • DCF_AGGREGATE_WITH_ERRORS 0x4000

source

INTEGER

NOT NULL

βˆ…

Source node. If this value is non-zero, server will query data from this node instead of the node specified by node_id. Reference to NODES.

snmp_port

INTEGER

NOT NULL

βˆ…

SNMP port.

datatype

INTEGER

NOT NULL

βˆ…

Type of data:

  • 0 - DCI_DT_INT

  • 1 - DCI_DT_UINT

  • 2 - DCI_DT_INT64

  • 3 - DCI_DT_UINT64

  • 4 - DCI_DT_STRING

  • 5 - DCI_DT_FLOAT

  • 6 - DCI_DT_NULL

  • 255 - DCI_DT_DEPRECATED (used internally by agent)

polling_interval

INTEGER

NOT NULL

βˆ…

Polling interval in seconds.

retention_time

INTEGER

NOT NULL

βˆ…

Retention time in days.

status

INTEGER

NOT NULL

βˆ…

Status of the DCI. Known values:

  • 0 – Active

  • 1 – Disabled

  • 2 – Not Supported

snmp_raw_value_type

INTEGER

NOT NULL

βˆ…

SNMP raw value type:

  • 0 - SNMP_RAWTYPE_NONE

  • 1 - SNMP_RAWTYPE_INT32

  • 2 - SNMP_RAWTYPE_UINT32

  • 3 - SNMP_RAWTYPE_INT64

  • 4 - SNMP_RAWTYPE_UINT64

  • 5 - SNMP_RAWTYPE_DOUBLE

  • 6 - SNMP_RAWTYPE_IP_ADDR

  • 7 - SNMP_RAWTYPE_MAC_ADDR

delta_calculation

INTEGER

NOT NULL

βˆ…

Delta calculation methods for DCI:

  • 0 - DCM_ORIGINAL_VALUE

  • 1 - DCM_SIMPLE

  • 2 - DCM_AVERAGE_PER_SECOND

  • 3 - DCM_AVERAGE_PER_MINUTE

transformation

TEXT

NULL

βˆ…

NXSL transformation script

instance

VARCHAR(255)

NULL

βˆ…

Instance

system_tag

VARCHAR(255)

NULL

βˆ…

System tag used by different system modules to save module information

resource_id

INTEGER

NOT NULL

βˆ…

Cluster resource id from CLUSTER_RESOURCES

proxy_node

INTEGER

NOT NULL

βˆ…

ID of the proxy node. Reference to NODES.

base_units

INTEGER

NOT NULL

βˆ…

DCI base units:

  • 0 - DCI_BASEUNITS_OTHER

  • 1 - DCI_BASEUNITS_CUSTOM

  • 2 - DCI_BASEUNITS_BYTES

  • 3 - DCI_BASEUNITS_BITS

  • 4 - DCI_BASEUNITS_SECONDS

  • 5 - DCI_BASEUNITS_PERCENTS

  • 6 - DCI_BASEUNITS_BITS_PER_SECOND

  • 7 - DCI_BASEUNITS_BYTES_PER_SECOND

unit_multiplier

INTEGER

NOT NULL

βˆ…

Reserved for future use.

custom_units_name

VARCHAR(63)

NULL

βˆ…

Reserved for future use.

perftab_settings

TEXT

NULL

βˆ…

Data collection table XML configuration for Performance tab

instd_method

INTEGER

NOT NULL

βˆ…

Method of instance discovery:

  • 0 – IDM_NONE

  • 1 – IDM_AGENT_LIST

  • 2 – IDM_AGENT_TABLE

  • 3 – IDM_SNMP_WALK_VALUES

  • 4 – IDM_SNMP_WALK_OIDS

  • 5 – IDM_SCRIPT

instd_data

VARCHAR(255)

NULL

βˆ…

Data for instance discovery (Srcipt name, Agent list…​)

instd_filter

TEXT

NULL

βˆ…

NXSL instance discovery filter

samples

INTEGER

NOT NULL

βˆ…

Number of samples used for reading counter (only for "Windows preformance counter" origin).

npe_name

VARCHAR(15)

NULL

βˆ…

Prediction engine name

comments

TEXT

NULL

βˆ…

Data collection item comment

instance_retention_time

INTEGER

NOT NULL

βˆ…

Retention time for deleted instances

grace_period_start

INTEGER

NOT NULL

βˆ…

Start for grade period for deleted instance

Table 122. Indexes

Name

Type

Fields

idx_items_node_id

NORMAL

node_id

items_pkey

UNIQUE

item_id

JOB_HISTORY

Server job history table

Table 123. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier.

time_created

INTEGER

NOT NULL

βˆ…

Time when job was created (as UNIX timestamp)

time_started

INTEGER

NOT NULL

βˆ…

Time when job was started (as UNIX timestamp)

time_finished

INTEGER

NOT NULL

βˆ…

Time when job has finished (as UNIX timestamp)

job_type

VARCHAR(127)

NULL

βˆ…

Type of job. Known types:

  • DOWNLOAD_FILE

  • UPLOAD_FILE

  • DEPLOY_AGENT_POLICY

  • UNINSTALL_AGENT_POLICY

description

VARCHAR(255)

NULL

βˆ…

Job description

additional_info

VARCHAR(255)

NULL

βˆ…

Additional job info

node_id

INTEGER

NOT NULL

βˆ…

Node id from NODES

user_id

INTEGER

NOT NULL

βˆ…

User id from USERS

status

INTEGER

NOT NULL

βˆ…

Job status:

  • 0 - JOB_PENDING

  • 1 - JOB_ACTIVE

  • 2 - JOB_ON_HOLD

  • 3 - JOB_COMPLETED

  • 4 - JOB_FAILED

  • 5 - JOB_CANCELLED

  • 6 - JOB_CANCEL_PENDING

failure_message

VARCHAR(255)

NULL

βˆ…

Description of fail

Table 124. Indexes

Name

Type

Fields

job_history_pkey

UNIQUE

id

LICENSES

License repository

Table 125. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

License unique identifier

content

TEXT

NULL

βˆ…

License content

Table 126. Indexes

Name

Type

Fields

licenses_pkey

UNIQUE

id

MAPPING_DATA

Mapping tables content

Table 127. Columns

Name

Type

State

Default

Description

πŸ”‘table_id

INTEGER

NOT NULL

βˆ…

Mapping table id form MAPPING_TABLES

πŸ”‘md_key

VARCHAR(63)

NOT NULL

βˆ…

Maping data key

md_value

VARCHAR(255)

NULL

βˆ…

Mapping data value

description

VARCHAR(4000)

NULL

βˆ…

Maping value description

Table 128. Indexes

Name

Type

Fields

mapping_data_pkey

UNIQUE

table_id,md_key

MAPPING_TABLES

Mapping tables

Table 129. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique mapping table id

name

VARCHAR(63)

NOT NULL

βˆ…

Mapping table name

flags

INTEGER

NOT NULL

βˆ…

Mapping table flags:

  • MTF_NUMERIC_KEYS 0x00000001

description

VARCHAR(4000)

NULL

βˆ…

Mapping table description

Table 130. Indexes

Name

Type

Fields

mapping_tables_pkey

UNIQUE

id

METADATA

System meta data (DBMS type, schema version, etc.)

Table 131. Columns

Name

Type

State

Default

Description

πŸ”‘var_name

VARCHAR(63)

NOT NULL

βˆ…

Variable name

var_value

VARCHAR(255)

NOT NULL

βˆ…

Variable value

Table 132. Indexes

Name

Type

Fields

metadata_pkey

UNIQUE

var_name

MOBILE_DEVICES

Mobile devices from object_properties

Table 133. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Mobile device id

device_id

VARCHAR(64)

NOT NULL

βˆ…

Device ID(IMEI or ESN)

vendor

VARCHAR(64)

NULL

βˆ…

Device vendor

model

VARCHAR(128)

NULL

βˆ…

Device model

serial_number

VARCHAR(64)

NULL

βˆ…

Serial number

os_name

VARCHAR(32)

NULL

βˆ…

Operating system name

os_version

VARCHAR(64)

NULL

βˆ…

Operation system version

user_id

VARCHAR(64)

NULL

βˆ…

User id

battery_level

INTEGER

NOT NULL

βˆ…

Battery charge level

Table 134. Indexes

Name

Type

Fields

mobile_devices_pkey

UNIQUE

id

NETWORK_MAP_ELEMENTS

Elements of network maps

Table 135. Columns

Name

Type

State

Default

Description

πŸ”‘map_id

INTEGER

NOT NULL

βˆ…

Network map id NETWORK_MAPS

πŸ”‘element_id

INTEGER

NOT NULL

βˆ…

Element id

element_type

INTEGER

NOT NULL

βˆ…

Element type:

  • 0 - MAP_ELEMENT_GENERIC

  • 1 - MAP_ELEMENT_OBJECT

  • 2 - MAP_ELEMENT_DECORATION

  • 3 - MAP_ELEMENT_DCI_CONTAINER

  • 4 - MAP_ELEMENT_DCI_IMAGE

  • 5 - MAP_ELEMENT_TEXT_BOX

element_data

TEXT

NOT NULL

βˆ…

Element data in XML format

flags

INTEGER

NOT NULL

βˆ…

Network map element flags. Currently there are no flags defined.

Table 136. Indexes

Name

Type

Fields

network_map_elements_pkey

UNIQUE

map_id,element_id

Links on network maps

Table 137. Columns

Name

Type

State

Default

Description

map_id

INTEGER

NOT NULL

βˆ…

Network map id from NETWORK_MAPS

element1

INTEGER

NOT NULL

βˆ…

Start element id from NETWORK_MAP_ELEMENTS

element2

INTEGER

NOT NULL

βˆ…

End element id NETWORK_MAP_ELEMENTS

link_type

INTEGER

NOT NULL

βˆ…

Link type:

  • 0 - LINK_TYPE_NORMAL

  • 1 - LINK_TYPE_VPN

  • 2 - LINK_TYPE_MULTILINK

link_name

VARCHAR(255)

NULL

βˆ…

Link name

connector_name1

VARCHAR(255)

NULL

βˆ…

First element connector name

connector_name2

VARCHAR(255)

NULL

βˆ…

Second element connector name

element_data

TEXT

NULL

βˆ…

Element XML configuration

flags

INTEGER

NOT NULL

βˆ…

Network map link flags. Currently there are no flags defined.

Table 138. Indexes

Name

Type

Fields

idx_network_map_links_map_id

NORMAL

map_id

NETWORK_MAP_SEED_NODES

Nodes that will be used as a start point for automatic map build.

Table 139. Columns

Name

Type

State

Default

Description

πŸ”‘map_id

INTEGER

NOT NULL

βˆ…

Network map id from NETWORK_MAPS

πŸ”‘seed_node_id

INTEGER

NOT NULL

βˆ…

Node is from NODES

Table 140. Indexes

Name

Type

Fields

network_map_seed_nodes_pkey

UNIQUE

map_id,seed_node_id

NETWORK_MAPS

Network maps

Table 141. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Network map id unique id from OBJECT_PROPERTIES

map_type

INTEGER

NOT NULL

βˆ…

Network map type:

  • 0 - MAP_TYPE_CUSTOM

  • 1 - MAP_TYPE_LAYER2_TOPOLOGY

  • 2 - MAP_TYPE_IP_TOPOLOGY

layout

INTEGER

NOT NULL

βˆ…

Network map layout:

  • 0x7FFF - MAP_LAYOUT_MANUAL

  • 0 - MAP_LAYOUT_SPRING

  • 1 - MAP_LAYOUT_RADIAL

  • 2 - MAP_LAYOUT_HTREE

  • 3 - MAP_LAYOUT_VTREE

  • 4 - MAP_LAYOUT_SPARSE_VTREE

radius

INTEGER

NOT NULL

βˆ…

Riscovery radius form automatic maps

background

VARCHAR(36)

NULL

βˆ…

UUID of background immage

bg_latitude

VARCHAR(20)

NULL

βˆ…

Background latitude, when map is used as a background

bg_longitude

VARCHAR(20)

NULL

βˆ…

Background longitude, when map is used as a background

bg_zoom

INTEGER

NULL

βˆ…

Background zoom, when map is used as a background

flags

INTEGER

NOT NULL

βˆ…

Network map flags:

  • MF_SHOW_STATUS_ICON 0x00000001

  • MF_SHOW_STATUS_FRAME 0x00000002

  • MF_SHOW_STATUS_BKGND 0x00000004

  • MF_SHOW_END_NODES 0x00000008

  • MF_CALCULATE_STATUS 0x00000010

  • MF_FILTER_OBJECTS 0x00000020

bg_color

INTEGER

NOT NULL

βˆ…

RGB representation of background color

link_color

INTEGER

NOT NULL

βˆ…

Default link color (RGB)

link_routing

INTEGER

NOT NULL

βˆ…

Default link routing:

  • 0 - ROUTING_DEFAULT

  • 1 - ROUTING_DIRECT

  • 2 - ROUTING_MANHATTAN

  • 3 - ROUTING_BENDPOINTS

object_display_mode

INTEGER

NOT NULL

βˆ…

Object display mode:

  • 0 - ICON

  • 1 - SMALL_LABEL

  • 2 - LARGE_LABEL

  • 3 - STATUS

  • 4 - FLOOR_PLAN

filter

TEXT

NULL

βˆ…

Network map NXSL object filter for automatic maps

Table 142. Indexes

Name

Type

Fields

network_maps_pkey

UNIQUE

id

NETWORK_SERVICES

Network services

Table 143. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Network service unique identifier from OBJECT_PROPERTIES

node_id

INTEGER

NOT NULL

βˆ…

Service location node id form NODES

service_type

INTEGER

NOT NULL

βˆ…

Service type:

  • 0 - NETSRV_CUSTOM

  • 1 - NETSRV_SSH

  • 2 - NETSRV_POP3

  • 3 - NETSRV_SMTP

  • 4 - NETSRV_FTP

  • 5 - NETSRV_HTTP

  • 6 - NETSRV_HTTPS

  • 7 - NETSRV_TELNET

ip_bind_addr

VARCHAR(48)

NOT NULL

βˆ…

Listen IP address

ip_proto

INTEGER

NOT NULL

βˆ…

IP protocol

ip_port

INTEGER

NOT NULL

βˆ…

TCP/UDP port

check_request

TEXT

NULL

βˆ…

Check request

check_responce

TEXT

NULL

βˆ…

Check response

poller_node_id

INTEGER

NOT NULL

βˆ…

Node id that does polling form NODES if polling should be done not from service parent node.

required_polls

INTEGER

NOT NULL

βˆ…

Number of pols required to change service status

Table 144. Indexes

Name

Type

Fields

network_services_pkey

UNIQUE

id

NODE_COMPONENTS

Node hardware components retrieved using Entity MIB.

Table 145. Columns

Name

Type

State

Default

Description

πŸ”‘node_id

INTEGER

NOT NULL

βˆ…

Node object ID. Reference to NODES.

πŸ”‘component_index

INTEGER

NOT NULL

βˆ…

Unique component index.

parent_index

INTEGER

NOT NULL

βˆ…

Index of parent component (0 for root component).

position

INTEGER

NOT NULL

βˆ…

Relative position within parent component.

component_class

INTEGER

NOT NULL

βˆ…

Physical class of the component.

  • 1 – Other

  • 2 – Unknown

  • 3 – Chassis

  • 4 – Backplane

  • 5 - Container

  • 6 - Power supply

  • 7 - Fan

  • 8 - Sensor

  • 9 - Module

  • 10 - Port

  • 11 - Stack

  • 12 - CPU

if_index

INTEGER

NOT NULL

βˆ…

Interface index of related network interface or 0.

name

VARCHAR(255)

NULL

βˆ…

Component’s name.

description

VARCHAR(255)

NULL

βˆ…

Component’s description.

model

VARCHAR(255)

NULL

βˆ…

Component’s model name.

serial_number

VARCHAR(63)

NULL

βˆ…

Component’s serial number.

vendor

VARCHAR(63)

NULL

βˆ…

Component’s vendor name.

firmware

VARCHAR(127)

NULL

βˆ…

Component’s firmware information.

Table 146. Indexes

Name

Type

Fields

node_components_pkey

UNIQUE

node_id, component_index

SLA node links

Table 147. Columns

Name

Type

State

Default

Description

πŸ”‘nodelink_id

INTEGER

NOT NULL

βˆ…

Unique node link id from OBJECT_PROPERTIES

node_id

INTEGER

NOT NULL

βˆ…

Node id form NODES

Table 148. Indexes

Name

Type

Fields

node_links_pkey

UNIQUE

nodelink_id

NODES

Nodes

Table 149. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Node id from OBJECT_PROPERTIES

primary_name

VARCHAR(255)

NULL

βˆ…

Primary host name

primary_ip

VARCHAR(48)

NOT NULL

βˆ…

Primary IP (resolved primary host name)

node_flags

INTEGER

NOT NULL

βˆ…

Node flags:

  • NF_REMOTE_AGENT 0x00000080

  • NF_SNMP_SETTINGS_LOCKED 0x00200000

  • NF_DISABLE_DISCOVERY_POLL 0x00400000

  • NF_DISABLE_TOPOLOGY_POLL 0x00800000

  • NF_DISABLE_SNMP 0x01000000

  • NF_DISABLE_NXCP 0x02000000

  • NF_DISABLE_ICMP 0x04000000

  • NF_FORCE_ENCRYPTION 0x08000000

  • NF_DISABLE_STATUS_POLL 0x10000000

  • NF_DISABLE_CONF_POLL 0x20000000

  • NF_DISABLE_ROUTE_POLL 0x40000000

  • NF_DISABLE_DATA_COLLECT 0x80000000

runtime_flags

INTEGER

NOT NULL

βˆ…

Runtime flags:

  • NDF_QUEUED_FOR_STATUS_POLL 0x000001

  • NDF_QUEUED_FOR_CONFIG_POLL 0x000002

  • NDF_UNREACHABLE 0x000004

  • NDF_AGENT_UNREACHABLE 0x000008

  • NDF_SNMP_UNREACHABLE 0x000010

  • NDF_QUEUED_FOR_DISCOVERY_POLL 0x000020

  • NDF_FORCE_STATUS_POLL 0x000040

  • NDF_FORCE_CONFIGURATION_POLL 0x000080

  • NDF_QUEUED_FOR_ROUTE_POLL 0x000100

  • NDF_CPSNMP_UNREACHABLE 0x000200

  • NDF_RECHECK_CAPABILITIES 0x000400

  • NDF_POLLING_DISABLED 0x000800

  • NDF_CONFIGURATION_POLL_PASSED 0x001000

  • NDF_QUEUED_FOR_TOPOLOGY_POLL 0x002000

  • NDF_DELETE_IN_PROGRESS 0x004000

  • NDF_NETWORK_PATH_PROBLEM 0x008000

  • NDF_QUEUED_FOR_INSTANCE_POLL 0x010000

  • NDF_CACHE_MODE_NOT_SUPPORTED 0x020000

  • NDF_NEW_TUNNEL_BIND 0x040000

snmp_version

INTEGER

NOT NULL

βˆ…

SNMP version

  • 0 - SNMP_VERSION_1

  • 1 - SNMP_VERSION_2C

  • 3 - SNMP_VERSION_3

snmp_port

INTEGER

NOT NULL

βˆ…

SNMP port

community

VARCHAR(127)

NULL

βˆ…

SNMP community string

usm_auth_password

VARCHAR(127)

NULL

βˆ…

SNMP v3 authentication password

usm_priv_password

VARCHAR(127)

NULL

βˆ…

SNMP v3 encryption password

usm_methods

INTEGER

NOT NULL

βˆ…

SNMP v3 authentication and ecryption methods

snmp_oid

VARCHAR(255)

NULL

βˆ…

SNMP object id

auth_method

INTEGER

NOT NULL

βˆ…

Agent authentication method

secret

VARCHAR(64)

NULL

βˆ…

Agent shared seecret

agent_port

INTEGER

NOT NULL

βˆ…

Agent port

status_poll_type

INTEGER

NOT NULL

βˆ…

Status poll types:

  • 0 - POLL_ICMP_PING

  • 1 - POLL_SNMP

  • 2 - POLL_NATIVE_AGENT

agent_version

VARCHAR(63)

NULL

βˆ…

Agent version

platform_name

VARCHAR(63)

NULL

βˆ…

Platform name as reported by agent

poller_node_id

INTEGER

NOT NULL

βˆ…

Id of node from NODES used for network service polling for this node

zone_guid

INTEGER

NOT NULL

βˆ…

Zone unique identification number from ZONES

proxy_node

INTEGER

NOT NULL

βˆ…

Agent proxy node id from NODES

snmp_proxy

INTEGER

NOT NULL

βˆ…

SNMP proxy node id from NODES

icmp_proxy

INTEGER

NOT NULL

βˆ…

ICMP proxy node id from NODES

required_polls

INTEGER

NOT NULL

βˆ…

Number of polls for status change

uname

VARCHAR(255)

NULL

βˆ…

System description

use_ifxtable

INTEGER

NOT NULL

βˆ…

ifXTable usage mode:

  • 0 - IFXTABLE_DEFAULT Use global settings

  • 1 - IFXTABLE_ENABLED

  • 2 - IFXTABLE_DISABLED

snmp_sys_name

VARCHAR(127)

NULL

βˆ…

System name as reported by SNMP agent

snmp_sys_contact

VARCHAR(127)

NULL

βˆ…

System contact as reported by SNMP agent

snmp_sys_location

VARCHAR(127)

NULL

βˆ…

System location as reported by SNMP agent

bridge_base_addr

VARCHAR(15)

NULL

βˆ…

Bridge base address

down_since

INTEGER

NOT NULL

βˆ…

Unix timestamp of last SYS_NODE_DOWN event

boot_time

INTEGER

NOT NULL

βˆ…

Node boot time (as UNIX timestamp)

driver_name

VARCHAR(32)

NULL

βˆ…

Network device driver name

rack_image_front

VARCHAR(36)

NULL

βˆ…

Image GUID to be used in front rack view

rack_position

INTEGER

NOT NULL

βˆ…

Position in rack (in rack units)

rack_height

INTEGER

NOT NULL

βˆ…

Height in rack (in rack units)

rack_id

INTEGER

NOT NULL

βˆ…

Related rack object ID

chassis_id

INTEGER

NOT NULL

βˆ…

ID of chassis object this node belongs to

agent_cache_mode

CHAR(1)

NOT NULL

βˆ…

Agent cache mode:

  • 0 - AGENT_CACHE_DEFAULT Use global configuration

  • 1 - AGENT_CACHE_ON

  • 2 - AGENT_CACHE_OFF

last_agent_comm_time

INTEGER

NOT NULL

βˆ…

Last agent communication time (as UNIX timestamp)

syslog_msg_count

BIGINT

NOT NULL

βˆ…

Total number of received syslog messages

snmp_trap_count

BIGINT

NOT NULL

βˆ…

Total number of received SNMP traps

node_type

INTEGER

NOT NULL

βˆ…

Node type:

  • 0 - NODE_TYPE_UNKNOWN

  • 1 - NODE_TYPE_PHYSICAL

  • 2 - NODE_TYPE_VIRTUAL

  • 3 - NODE_TYPE_CONTROLLER

  • 4 - NODE_TYPE_CONTAINER

node_subtype

VARCHAR(127)

NULL

βˆ…

Node sub-type

ssh_login

VARCHAR(63)

NULL

βˆ…

SSH login

ssh_password

VARCHAR(63)

NULL

βˆ…

SSH password

ssh_proxy

INTEGER

NOT NULL

βˆ…

SSH proxy node id from NODES

port_rows

INTEGER

NOT NULL

βˆ…

Number of port rows

port_numbering_scheme

INTEGER

NOT NULL

βˆ…

Numbering scheme of ports

agent_comp_mode

CHAR(1)

NOT NULL

βˆ…

Agent compression mode:

  • 0 - NODE_AGENT_COMPRESSION_DEFAULT Use global configuration

  • 1 - NODE_AGENT_COMPRESSION_ENABLED

  • 2 - NODE_AGENT_COMPRESSION_DISABLED

tunnel_id

VARCHAR(36)

NULL

βˆ…

GUID of bound tunnel

lldp_id

VARCHAR(63)

NULL

βˆ…

LLDP id

fail_time_snmp

INTEGER

NOT NULL

βˆ…

Last SNMP request file time

fail_time_agent

INTEGER

NOT NULL

βˆ…

Last agent request file time

rack_orientation

INTEGER

NOT NULL

βˆ…

Rack orientation type:

  • 0 - FILL

  • 1 - FRONT

  • 2 - REAR

rack_image_rear

VARCHAR(36)

NOT NULL

βˆ…

Image GUID to be used in rear rack view

agent_id

VARCHAR(36)

NULL

βˆ…

Agent id

agent_cert_subject

VARCHAR(500)

NULL

βˆ…

Agent certificate subject

hypervisor_type

VARCHAR(31)

NULL

βˆ…

Hypervisor type. Wel known types:

  • OpenVZ

  • Linux-VServer

  • LXC

  • Docker

  • XEN

  • VMware

  • Hyper-V

  • KVM

  • bhyve

  • Parallels

  • VirtualBox

hypervisor_info

VARCHAR(255)

NULL

βˆ…

Hypervisor info that might be or might not be. There can be some version information.

Table 150. Indexes

Name

Type

Fields

nodes_pkey

UNIQUE

id

NSMAP

Nodes to subnets mapping

Table 151. Columns

Name

Type

State

Default

Description

πŸ”‘subnet_id

INTEGER

NOT NULL

βˆ…

Subnet id from SUBNETS

πŸ”‘node_id

INTEGER

NOT NULL

βˆ…

Node id from NODES

Table 152. Indexes

Name

Type

Fields

nsmap_pkey

UNIQUE

subnet_id,node_id

OBJECT_ACCESS_SNAPSHOT

Snapshot for object access rights

Table 153. Columns

Name

Type

State

Default

Description

πŸ”‘user_id

INTEGER

NOT NULL

βˆ…

User id from USERS

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Object id from OBJECT_PROPERTIES.

access_rights

INTEGER

NOT NULL

βˆ…

Access rights:

  • OBJECT_ACCESS_READ 0x00000001

  • OBJECT_ACCESS_MODIFY 0x00000002

  • OBJECT_ACCESS_CREATE 0x00000004

  • OBJECT_ACCESS_DELETE 0x00000008

  • OBJECT_ACCESS_READ_ALARMS 0x00000010

  • OBJECT_ACCESS_ACL 0x00000020

  • OBJECT_ACCESS_UPDATE_ALARMS 0x00000040

  • OBJECT_ACCESS_SEND_EVENTS 0x00000080

  • OBJECT_ACCESS_CONTROL 0x00000100

  • OBJECT_ACCESS_TERM_ALARMS 0x00000200

  • OBJECT_ACCESS_PUSH_DATA 0x00000400

  • OBJECT_ACCESS_CREATE_ISSUE 0x00000800

  • OBJECT_ACCESS_DOWNLOAD 0x00001000

  • OBJECT_ACCESS_UPLOAD 0x00002000

  • OBJECT_ACCESS_MANAGE_FILES 0x00004000

  • OBJECT_ACCESS_MAINTENANCE 0x00008000

  • OBJECT_ACCESS_READ_AGENT 0x00010000

  • OBJECT_ACCESS_READ_SNMP 0x00020000

  • OBJECT_ACCESS_SCREENSHOT 0x00040000

Table 154. Indexes

Name

Type

Fields

object_access_snapshot_pkey

UNIQUE

user_id,object_id

OBJECT_CONTAINERS

All types of object containers like: node container, template group, policy group, network map group, business services, node link and deshboard group.

Table 155. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier.

object_class

INTEGER

NOT NULL

βˆ…

Object class:

  • 5 - OBJECT_CONTAINER

  • 9 - OBJECT_TEMPLATEGROUP

  • 15 - OBJECT_POLICYGROUP

  • 20 - OBJECT_NETWORKMAPGROUP

  • 28 - OBJECT_BUSINESSSERVICE

  • 29 - OBJECT_NODELINK

  • 36 - OBJECT_DASHBOARDGROUP

flags

INTEGER

NOT NULL

βˆ…

Flags:

  • CF_AUTO_BIND 0x00000001

  • CF_AUTO_UNBIND 0x00000002

auto_bind_filter

TEXT

NULL

βˆ…

NXSL autobind filter script.

Table 156. Indexes

Name

Type

Fields

object_containers_pkey

UNIQUE

id

OBJECT_CUSTOM_ATTRIBUTES

Object custom attributes

Table 157. Columns

Name

Type

State

Default

Description

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Object id from object_properties

πŸ”‘attr_name

VARCHAR(127)

NOT NULL

βˆ…

Object attribute name

attr_value

TEXT

NULL

βˆ…

Object attribute value

Table 158. Indexes

Name

Type

Fields

idx_ocattr_oid

NORMAL

object_id

object_custom_attributes_pkey

UNIQUE

object_id,attr_name

OBJECT_PROPERTIES

Object properties of NetObj and everything that is inherited from it(Dashboard, Interface, Node…​)

Table 159. Columns

Name

Type

State

Default

Description

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Object id

guid

VARCHAR(36)

NOT NULL

βˆ…

Object GUID

name

VARCHAR(63)

NOT NULL

βˆ…

Object name

status

INTEGER

NOT NULL

βˆ…

Object status(Unknown, Normal, Warning, Minor …​)

is_deleted

INTEGER

NOT NULL

βˆ…

Flag that defines if this object is scheduled for deletion

is_system

INTEGER

NOT NULL

βˆ…

Flag that defines if this object is the system object(DashboardRoot, ServiceRoot…​)

last_modified

INTEGER

NOT NULL

βˆ…

Timestamp when this object was last modified

inherit_access_rights

INTEGER

NOT NULL

βˆ…

Defins if current object inherits access rights form parent (0 or 1)

status_calc_alg

INTEGER

NOT NULL

βˆ…

Status calculation algorithms:

  • 0 - SA_CALCULATE_DEFAULT

  • 1 - SA_CALCULATE_MOST_CRITICAL

  • 2 - SA_CALCULATE_SINGLE_THRESHOLD

  • 3 - SA_CALCULATE_MULTIPLE_THRESHOLDS

status_prop_alg

INTEGER

NOT NULL

βˆ…

Status propagation algorithms

  • 0 - SA_PROPAGATE_DEFAULT

  • 1 - SA_PROPAGATE_UNCHANGED

  • 2 - SA_PROPAGATE_FIXED

  • 3 - SA_PROPAGATE_RELATIVE

  • 4 - SA_PROPAGATE_TRANSLATED

status_fixed_val

INTEGER

NOT NULL

βˆ…

Fixed value for status if SA_PROPAGATE_FIXED propagation algorithms is used. Status options:

  • 0 - STATUS_NORMAL

  • 1 - STATUS_WARNING

  • 2 - STATUS_MINOR

  • 3 - STATUS_MAJOR

  • 4 - STATUS_CRITICAL

  • 5 - STATUS_UNKNOWN

  • 6 - STATUS_UNMANAGED

  • 7 - STATUS_DISABLED

  • 8 - STATUS_TESTING

status_shift

INTEGER

NOT NULL

βˆ…

Number of positions status is shifted (status+status_shift)

status_translation

VARCHAR(8)

NOT NULL

βˆ…

HEX string containing 4 bytes. Each byte represents a status mapping in status propagation configuration. Status byte order:

  • 1 warning

  • 2 medium

  • 3 major

  • 4 critical

status_single_threshold

INTEGER

NOT NULL

βˆ…

"Single threshold" value in status colculation

status_thresholds

VARCHAR(8)

NOT NULL

βˆ…

HEX string containing 4 bytes. Each byte represents threshold value for "Multiple thresholds" status calculation configuration. Status byte order:

  • 1 warning

  • 2 medium

  • 3 major

  • 4 critical

comments

TEXT

NULL

βˆ…

Comments

location_type

INTEGER

NOT NULL

βˆ…

Lacation type(Undefined, Manual, Automatic)

latitude

VARCHAR(20)

NULL

βˆ…

Latitude value

longitude

VARCHAR(20)

NULL

βˆ…

Longitude value

location_accuracy

INTEGER

NOT NULL

βˆ…

Received location accuracy

location_timestamp

INTEGER

NOT NULL

βˆ…

Last received location time

image

VARCHAR(36)

NOT NULL

βˆ…

Immage GUID form IMAGES, that will be used to display object on network maps.

submap_id

INTEGER

NOT NULL

βˆ…

Drill down object id from NETWORK_MAPS or DASHBOARDS

country

VARCHAR(63)

NULL

βˆ…

Object location country

city

VARCHAR(63)

NULL

βˆ…

Object location city

street_address

VARCHAR(255)

NULL

βˆ…

Object location address

postcode

VARCHAR(31)

NULL

βˆ…

Object location postcode

maint_event_id

BIGINT

NOT NULL

βˆ…

Event id of maintenance entered event if currently in maintenance mode

state_before_maint

INTEGER

NOT NULL

βˆ…

State before maintenance

Table 160. Indexes

Name

Type

Fields

object_properties_pkey

UNIQUE

object_id

OBJECT_TOOLS_ACL

Access list for object tools

Table 161. Columns

Name

Type

State

Default

Description

πŸ”‘tool_id

INTEGER

NOT NULL

βˆ…

Tool id from OBJECT_TOOLS

πŸ”‘user_id

INTEGER

NOT NULL

βˆ…

User id form USERS

Table 162. Indexes

Name

Type

Fields

object_tools_acl_pkey

UNIQUE

tool_id,user_id

OBJECT_TOOLS_INPUT_FIELDS

Input fields for object tools

Table 163. Columns

Name

Type

State

Default

Description

πŸ”‘tool_id

INTEGER

NOT NULL

βˆ…

Object tool id from OBJECT_TOOLS

πŸ”‘name

VARCHAR(31)

NOT NULL

βˆ…

Input field name

input_type

CHAR(1)

NOT NULL

βˆ…

Input type:

  • 0 - TEXT

  • 1 - PASSWORD

  • 2 - NUMBER

display_name

VARCHAR(127)

NULL

βˆ…

Input field display name

sequence_num

INTEGER

NOT NULL

βˆ…

Input field sequence number

config

TEXT

NULL

βˆ…

XML config of input field

Table 164. Indexes

Name

Type

Fields

object_tools_input_fields_pkey

UNIQUE

tool_id,name

OBJECT_TOOLS_TABLE_COLUMNS

Configuration of columns for SNMP_TABLE and AGENT_TABLE type of object tools

Table 165. Columns

Name

Type

State

Default

Description

πŸ”‘tool_id

INTEGER

NOT NULL

βˆ…

Tool id from OBJECT_TOOLS

πŸ”‘col_number

INTEGER

NOT NULL

βˆ…

Column number

col_name

VARCHAR(255)

NULL

βˆ…

Column name

col_oid

VARCHAR(255)

NULL

βˆ…

Column oid

col_format

INTEGER

NULL

βˆ…

Column format:

  • 0 - FORMAT_STRING

  • 1 - FORMAT_INTEGER

  • 2 - FORMAT_FLOAT

  • 3 - FORMAT_IP_ADDR

  • 4 - FORMAT_MAC_ADDR

  • 5 - FORMAT_IFINDEX

col_substr

INTEGER

NULL

βˆ…

Number of subsrging generated by regexp defined in OBJECT_TOOLS for this object tool.

Table 166. Indexes

Name

Type

Fields

object_tools_table_columns_pkey

UNIQUE

tool_id,col_number

OBJECT_TOOLS

Object tools

Table 167. Columns

Name

Type

State

Default

Description

πŸ”‘tool_id

INTEGER

NOT NULL

βˆ…

Object tool unique identifier

guid

VARCHAR(36)

NOT NULL

βˆ…

Object tool GUID

tool_name

VARCHAR(255)

NULL

βˆ…

Object tool name

tool_type

INTEGER

NOT NULL

βˆ…

Object tool type:

  • 0 - TYPE_INTERNAL

  • 1 - TYPE_ACTION

  • 2 - TYPE_TABLE_SNMP

  • 3 - TYPE_TABLE_AGENT

  • 4 - TYPE_URL

  • 5 - TYPE_LOCAL_COMMAND

  • 6 - TYPE_SERVER_COMMAND

  • 7 - TYPE_FILE_DOWNLOAD

  • 8 - TYPE_SERVER_SCRIPT

tool_data

TEXT

NULL

βˆ…

Tool data (file name for file download, or command name for internal command…​)

description

VARCHAR(255)

NULL

βˆ…

Object tool description

flags

INTEGER

NOT NULL

βˆ…

Object tool flags:

  • 0x00000001 - ASK_CONFIRMATION

  • 0x00000002 - GENERATES_OUTPUT

  • 0x00000004 - DISABLED

  • 0x00000008 - SHOW_IN_COMMANDS

  • 0x00000010 - SNMP_INDEXED_BY_VALUE

tool_filter

TEXT

NULL

βˆ…

XML configuration for filtring objects object tool to be shown on

confirmation_text

VARCHAR(255)

NULL

βˆ…

Confirmation text

command_name

VARCHAR(255)

NULL

βˆ…

Command name (with path)

command_short_name

VARCHAR(31)

NULL

βˆ…

Command short name

icon

TEXT

NULL

βˆ…

Command icon

Table 168. Indexes

Name

Type

Fields

object_tools_pkey

UNIQUE

tool_id

OBJECT_URLS

URLs that can be configured on External Resources property page of object and are shown on object overview page.

Table 169. Columns

Name

Type

State

Default

Description

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Object is from OBJECT_PROPERTIES.

πŸ”‘url_id

INTEGER

NOT NULL

βˆ…

URL id. Unique amoung URLs of one object

url

VARCHAR(2000)

NULL

βˆ…

URL

description

VARCHAR(2000)

NULL

βˆ…

URL description

Table 170. Indexes

Name

Type

Fields

object_urls_pkey

UNIQUE

object_id,url_id

ORGANIZATIONS

Reserved for future use.

Table 171. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

parent_id

INTEGER

NOT NULL

βˆ…

org_type

INTEGER

NOT NULL

βˆ…

name

VARCHAR(63)

NOT NULL

βˆ…

description

VARCHAR(255)

NULL

βˆ…

manager

INTEGER

NOT NULL

βˆ…

Table 172. Indexes

Name

Type

Fields

organizations_pkey

UNIQUE

id

PERSISTENT_STORAGE

Persistent storage table accessible from EPP and any script

Table 173. Columns

Name

Type

State

Default

Description

πŸ”‘entry_key

VARCHAR(255)

NOT NULL

βˆ…

Unique string key

value

VARCHAR(2000)

NULL

βˆ…

Value

Table 174. Indexes

Name

Type

Fields

persistent_storage_pkey

UNIQUE

entry_key

PERSONS

Reserved for future use.

Table 175. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

org_id

INTEGER

NOT NULL

βˆ…

first_name

VARCHAR(63)

NULL

βˆ…

last_name

VARCHAR(63)

NULL

βˆ…

title

VARCHAR(255)

NULL

βˆ…

status

INTEGER

NOT NULL

βˆ…

Table 176. Indexes

Name

Type

Fields

persons_pkey

UNIQUE

id

POLICY_ACTION_LIST

Event processing policy actions

Table 177. Columns

Name

Type

State

Default

Description

πŸ”‘rule_id

INTEGER

NOT NULL

βˆ…

Event processing policy rule id from EVENT_POLICY

πŸ”‘action_id

INTEGER

NOT NULL

βˆ…

Action id from ACTIONS

timer_delay

INTEGER

NOT NULL

βˆ…

Time to wait befor action to be executed

timer_key

VARCHAR(127)

NULL

βˆ…

Timmer key

Table 178. Indexes

Name

Type

Fields

policy_action_list_pkey

UNIQUE

rule_id,action_id

POLICY_EVENT_LIST

Event processing policy events

Table 179. Columns

Name

Type

State

Default

Description

πŸ”‘rule_id

INTEGER

NOT NULL

βˆ…

Rule id from EVENT_POLICY

πŸ”‘event_code

INTEGER

NOT NULL

βˆ…

Event id form EVENT_CFG

Table 180. Indexes

Name

Type

Fields

policy_event_list_pkey

UNIQUE

rule_id,event_code

POLICY_PSTORAGE_ACTIONS

Table that links epp with persistent storage

Table 181. Columns

Name

Type

State

Default

Description

πŸ”‘rule_id

INTEGER

NOT NULL

βˆ…

Foreign key from EVENT_POLICY table

πŸ”‘ps_key

VARCHAR(255)

NOT NULL

βˆ…

Persistent storage key

value

VARCHAR(2000)

NULL

βˆ…

Value that should be set for persistent storage entry

πŸ”‘action

INTEGER

NOT NULL

βˆ…

Action that should be done on persistent storage entry set/delete

Table 182. Indexes

Name

Type

Fields

policy_pstorage_actions_pkey

UNIQUE

rule_id,ps_key,action

POLICY_SOURCE_LIST

Event processing policy source objects

Table 183. Columns

Name

Type

State

Default

Description

πŸ”‘rule_id

INTEGER

NOT NULL

βˆ…

Rule id from EVENT_POLICY

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Object id from OBJECT_PROPERTIES

Table 184. Indexes

Name

Type

Fields

policy_source_list_pkey

UNIQUE

rule_id,object_id

POLICY_TIMER_CANCELATION_LIST

List of cancelation action for EPP action delay timers

Table 185. Columns

Name

Type

State

Default

Description

πŸ”‘rule_id

INTEGER

NOT NULL

βˆ…

Rule id from EVENT_POLICY

πŸ”‘timer_key

VARCHAR(127)

NOT NULL

βˆ…

Timer key from SCHEDULED_TASKS task_key

Table 186. Indexes

Name

Type

Fields

policy_timer_cancellation_list_pkey

UNIQUE

rule_id,timer_key

PORT_LAYOUTS

List of possible port layout options

Table 187. Columns

Name

Type

State

Default

Description

πŸ”‘device_oid

VARCHAR(255)

NOT NULL

βˆ…

Device OID

numbering_scheme

CHAR(1)

NOT NULL

βˆ…

Numbering scheme

  • 0 - port layout not known to driver

  • 1 - custom layout, driver defines location of each port

  • 2 - left-to-right, then up-down

    1 2 3 4
    5 6 7 8
  • 3 - left-to-right, then down-up

    5 6 7 8
    1 2 3 4
  • 4 - up-down, then left-right

    1 3 5 7
    2 4 6 8
  • 5 - down-up, then left-right

    2 4 6 8
    1 3 5 7

row_count

CHAR(1)

NULL

βˆ…

Number of rows

layout_data

VARCHAR(4000)

NULL

βˆ…

Custom layout data. Reserved for future use.

Table 188. Indexes

Name

Type

Fields

port_layouts_pkey

UNIQUE

device_oid

RACKS

Racks

Table 189. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Rack id from object_properties

height

INTEGER

NOT NULL

βˆ…

Rack height in units

top_bottom_num

CHAR(1)

NOT NULL

βˆ…

If rack numbering starts from the top or form the buttom (true/false)

passive_elements

TEXT

NULL

βˆ…

Rack passive elements

Table 190. Indexes

Name

Type

Fields

racks_pkey

UNIQUE

id

RAW_DCI_VALUES

Last collected DCI values

Table 191. Columns

Name

Type

State

Default

Description

πŸ”‘item_id

INTEGER

NOT NULL

βˆ…

DCI item id form ITEMS

raw_value

VARCHAR(255)

NULL

βˆ…

Raw DCI value

transformed_value

VARCHAR(255)

NULL

βˆ…

Transformed DCI value

last_poll_time

INTEGER

NOT NULL

βˆ…

Last poll time (as UNIx timestamp)

Table 192. Indexes

Name

Type

Fields

raw_dci_values_pkey

UNIQUE

item_id

SCHEDULED_TASKS

Scheduled task information

Table 193. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier.

taskid

VARCHAR(255)

NULL

βˆ…

Task type. Known types:

  • Execute.Action

  • Execute.Script

  • Maintenance.Enter

  • Maintenance.Leave

  • Policy.Deploy

  • Policy.Uninstall

  • Alarms.SendSummaryEmail

  • AgentTunnels.ProcessUnbound

schedule

VARCHAR(127)

NULL

βˆ…

Cron execution schedule - will not be set for one time tasks

params

VARCHAR(1023)

NULL

βˆ…

Scheduled task parameters (script name in case if script execution scheduled, …​)

execution_time

INTEGER

NOT NULL

βˆ…

The time when action should be executed - will be set only for one time task

last_execution_time

INTEGER

NOT NULL

βˆ…

Timestamp of last execution time

flags

INTEGER

NOT NULL

βˆ…

Flags:

  • 1 - DISABLED

  • 2 - EXECUTED

  • 4 - RUNNING

  • 8 - SYSTEM

owner

INTEGER

NOT NULL

βˆ…

Scheduled task owner from USERS

object_id

INTEGER

NOT NULL

βˆ…

Scheduled task object from OBJECT_PROPERTIES

comments

VARCHAR(255)

NULL

βˆ…

Scheduled task comment. Free format text.

task_key

VARCHAR(255)

NULL

βˆ…

Scheduled task text key

Table 194. Indexes

Name

Type

Fields

scheduled_tasks_pkey

UNIQUE

id

SCRIPT_LIBRARY

Script library

Table 195. Columns

Name

Type

State

Default

Description

guid

VARCHAR(36)

NOT NULL

βˆ…

Script GUID

πŸ”‘script_id

INTEGER

NOT NULL

βˆ…

Script unique identifier

script_name

VARCHAR(255)

NOT NULL

βˆ…

Script name

script_code

TEXT

NULL

βˆ…

NXSL script

Table 196. Indexes

Name

Type

Fields

script_library_pkey

UNIQUE

script_id

SLM_AGREEMENTS

SLA - agreements. Reserved for future use.

Table 197. Columns

Name

Type

State

Default

Description

πŸ”‘agreement_id

INTEGER

NOT NULL

βˆ…

Unique agreement id

service_id

INTEGER

NOT NULL

βˆ…

Service id

org_id

INTEGER

NOT NULL

βˆ…

Origin id

uptime

VARCHAR(63)

NOT NULL

βˆ…

Required uptime

period

INTEGER

NOT NULL

βˆ…

Period

start_date

INTEGER

NOT NULL

βˆ…

Start date

notes

VARCHAR(255)

NULL

βˆ…

Notes

Table 198. Indexes

Name

Type

Fields

slm_agreements_pkey

UNIQUE

agreement_id

SLM_CHECKS

SLA service checks

Table 199. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique SLM check

type

INTEGER

NOT NULL

βˆ…

Type:

  • 1 - threshold

  • 2 - script

content

TEXT

NULL

βˆ…

NXSL script chack

threshold_id

INTEGER

NOT NULL

βˆ…

Threshold id. Reserved for future use.

reason

VARCHAR(255)

NULL

βˆ…

Reason

is_template

INTEGER

NOT NULL

βˆ…

Defines if this object is template object

template_id

INTEGER

NOT NULL

βˆ…

Service check tebplate id form SLM_CHECKS

current_ticket

INTEGER

NOT NULL

βˆ…

Current ticket

Table 200. Indexes

Name

Type

Fields

slm_checks_pkey

UNIQUE

id

SLM_SERVICE_HISTORY

SLA service change log

Table 201. Columns

Name

Type

State

Default

Description

πŸ”‘record_id

INTEGER

NOT NULL

βˆ…

Service check log id

service_id

INTEGER

NOT NULL

βˆ…

Service id

change_timestamp

INTEGER

NOT NULL

βˆ…

Change timestamp

new_status

INTEGER

NOT NULL

βˆ…

Status:

  • 0 - STATUS_NORMAL

  • 1 - STATUS_WARNING

  • 2 - STATUS_MINOR

  • 3 - STATUS_MAJOR

  • 4 - STATUS_CRITICAL

  • 5 - STATUS_UNKNOWN

  • 6 - STATUS_UNMANAGED

  • 7 - STATUS_DISABLED

  • 8 - STATUS_TESTING

Table 202. Indexes

Name

Type

Fields

slm_service_history_pkey

UNIQUE

record_id

SLM_TICKETS

SLA tickets

Table 203. Columns

Name

Type

State

Default

Description

πŸ”‘ticket_id

INTEGER

NOT NULL

βˆ…

Ticker id

service_id

INTEGER

NOT NULL

βˆ…

Service id

check_id

INTEGER

NOT NULL

βˆ…

Cehck id

create_timestamp

INTEGER

NOT NULL

βˆ…

Creation timestamp

close_timestamp

INTEGER

NOT NULL

βˆ…

Clos timestamp

reason

VARCHAR(255)

NULL

βˆ…

Reason

Table 204. Indexes

Name

Type

Fields

slm_tickets_pkey

UNIQUE

ticket_id

SNMP_COMMUNITIES

List of possible community strings

Table 205. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique comunity id

community

VARCHAR(255)

NULL

βˆ…

SNMP comunity

Table 206. Indexes

Name

Type

Fields

snmp_communities_pkey

UNIQUE

id

SNMP_TRAP_CFG

SNMP trap configuration

Table 207. Columns

Name

Type

State

Default

Description

guid

VARCHAR(36)

NOT NULL

βˆ…

SNMP trap GUID

πŸ”‘trap_id

INTEGER

NOT NULL

βˆ…

SNMP trap configuration id

snmp_oid

VARCHAR(255)

NULL

βˆ…

SNMP trap oid

event_code

INTEGER

NOT NULL

βˆ…

Event code form EVENT_CFG. Will be generated in case if trap will come.

user_tag

VARCHAR(63)

NULL

βˆ…

User tag

description

VARCHAR(255)

NULL

βˆ…

Description

Table 208. Indexes

Name

Type

Fields

snmp_trap_cfg_pkey

UNIQUE

trap_id

SNMP_TRAP_LOG

Extended SNMP trap log

Table 209. Columns

Name

Type

State

Default

Description

πŸ”‘trap_id

BIGINT

NOT NULL

βˆ…

Unique trap id

trap_timestamp

INTEGER

NOT NULL

βˆ…

Trap timestamp (UNIX timestamp)

ip_addr

VARCHAR(48)

NOT NULL

βˆ…

Trap source IP address

object_id

INTEGER

NOT NULL

βˆ…

Trap source object id from NODES

trap_oid

VARCHAR(255)

NOT NULL

βˆ…

Trap oid

trap_varlist

TEXT

NULL

βˆ…

Trap variable list

zone_uin

INTEGER

NULL

βˆ…

Zone unique identification number from ZONES

Table 210. Indexes

Name

Type

Fields

idx_snmp_trap_log_oid

NORMAL

object_id

idx_snmp_trap_log_tt

NORMAL

trap_timestamp

snmp_trap_log_pkey

UNIQUE

trap_id

SNMP_TRAP_PMAP

SNMP trap parameters mapping

Table 211. Columns

Name

Type

State

Default

Description

πŸ”‘trap_id

INTEGER

NOT NULL

βˆ…

Trap id from SNMP_TRAP_CFG

πŸ”‘parameter

INTEGER

NOT NULL

βˆ…

Parameter sequence number

flags

INTEGER

NOT NULL

βˆ…

Flags:

  • 0 - BY_OBJECT_ID

  • 1 - BY_POSITION

snmp_oid

VARCHAR(255)

NULL

βˆ…

SNMP trap oid

description

VARCHAR(255)

NULL

βˆ…

Description

Table 212. Indexes

Name

Type

Fields

snmp_trap_pmap_pkey

UNIQUE

trap_id,parameter

SUBNETS

Subnets

Table 213. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

ID of the object. Reference to OBJECT_PROPERTIES.

ip_addr

VARCHAR(48)

NOT NULL

βˆ…

Subnet IP address

ip_netmask

INTEGER

NOT NULL

βˆ…

Subnet network mask

zone_guid

INTEGER

NOT NULL

βˆ…

Zone unique identification number from ZONES

synthetic_mask

INTEGER

NOT NULL

βˆ…

Subnet synthetic network mask

Table 214. Indexes

Name

Type

Fields

subnets_pkey

UNIQUE

id

SYSLOG

Stored syslog messages

Table 215. Columns

Name

Type

State

Default

Description

πŸ”‘msg_id

BIGINT

NOT NULL

βˆ…

Unique identifier

msg_timestamp

INTEGER

NOT NULL

βˆ…

Syslog message timestamp (as UNIX timestamp)

facility

INTEGER

NOT NULL

βˆ…

Facility

severity

INTEGER

NOT NULL

βˆ…

Severity

source_object_id

INTEGER

NOT NULL

βˆ…

Source object id from NODES

hostname

VARCHAR(127)

NULL

βˆ…

Source object host name

msg_tag

VARCHAR(32)

NULL

βˆ…

Syslog message tag

msg_text

TEXT

NULL

βˆ…

Syslog message text

zone_uin

INTEGER

NULL

βˆ…

Zone unique identification number from ZONES

Table 216. Indexes

Name

Type

Fields

idx_syslog_source

NORMAL

source_object_id

idx_syslog_msg_timestamp

NORMAL

msg_timestamp

syslog_pkey

UNIQUE

msg_id

TDATA_<NODE_ID>

Contains historical values for table DCIs for the node. Table name is dynamic, <NODE_ID> is replaced by actuall node id (e.g. "TDATA_100"). The table is populated only if single table performance data is disabled.

Table 217. Columns

Name

Type

State

Default

Description

πŸ”‘item_id

INTEGER

NOT NULL

βˆ…

Item id from DC_TABLES

πŸ”‘tdata_timestamp

INTEGER

NOT NULL

βˆ…

Unix time stamp

tdata_value

TEXT

NULL

βˆ…

Collected value.

Table 218. Indexes

Name

Type

Fields

idx_tdata_<NODE_ID>

NORMAL

item_id,tdata_timestamp

TDATA

Contains historical values for table DCIs for the node. The table is populated only if single table performance data is enabled.

Table 219. Columns

Name

Type

State

Default

Description

πŸ”‘node_id

INTEGER

NOT NULL

βˆ…

Object id from OBJECT_PROPERTIES

πŸ”‘item_id

INTEGER

NOT NULL

βˆ…

Item id from DC_TABLES

πŸ”‘tdata_timestamp

INTEGER

NOT NULL

βˆ…

Unix time stamp for collected value

tdata_value

TEXT

NULL

βˆ…

Collected value.

Table 220. Indexes

Name

Type

Fields

tdata_key

NORMAL

node_id,item_id,tdata_timestamp

TEMPLATES

Data collection templates

Table 221. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Unique identifier

version

INTEGER

NOT NULL

βˆ…

Template version

flags

INTEGER

NOT NULL

βˆ…

Template flags:

  • TF_AUTO_APPLY 0x00000001

  • TF_AUTO_REMOVE 0x00000002

apply_filter

TEXT

NULL

βˆ…

NXSL template auto apply script.

Table 222. Indexes

Name

Type

Fields

templates_pkey

UNIQUE

id

THRESHOLDS

Threshold checking rules

Table 223. Columns

Name

Type

State

Default

Description

πŸ”‘threshold_id

INTEGER

NOT NULL

βˆ…

Threshold unique identifier

item_id

INTEGER

NOT NULL

βˆ…

Item id from ITEMS

sequence_number

INTEGER

NOT NULL

βˆ…

Rule sequence number

fire_value

VARCHAR(255)

NULL

βˆ…

Fire value

rearm_value

VARCHAR(255)

NULL

βˆ…

Rearm value (not used)

check_function

INTEGER

NOT NULL

βˆ…

Threshold functions:

  • 0 - F_LAST

  • 1 - F_AVERAGE

  • 2 - F_DEVIATION

  • 3 - F_DIFF

  • 4 - F_ERROR

  • 5 - F_SUM

  • 6 - F_SCRIPT

check_operation

INTEGER

NOT NULL

βˆ…

Threshold operations:

  • 0 - OP_LE

  • 1 - OP_LE_EQ

  • 2 - OP_EQ

  • 3 - OP_GT_EQ

  • 4 - OP_GT

  • 5 - OP_NE

  • 6 - OP_LIKE

  • 7 - OP_NOTLIKE

sample_count

INTEGER

NOT NULL

βˆ…

Number of samples

script

TEXT

NULL

βˆ…

NXSL comparison script

event_code

INTEGER

NOT NULL

βˆ…

Event conde to fire in case of threshold violation from EVENT_CFG

rearm_event_code

INTEGER

NOT NULL

βˆ…

Event conde to fire in case of threshold rearm from EVENT_CFG

repeat_interval

INTEGER

NOT NULL

βˆ…

Event generation repeat interval

current_state

INTEGER

NOT NULL

βˆ…

Current threshold state (reach or not)

current_severity

INTEGER

NOT NULL

βˆ…

Current severity

match_count

INTEGER

NOT NULL

βˆ…

Threshold match count

last_event_timestamp

INTEGER

NOT NULL

βˆ…

Last generated event timestamp (as UNIX timestamp)

state_before_maint

CHAR(1)

NOT NULL

βˆ…

Threshold state before maintenance

last_checked_value

VARCHAR(255)

NULL

βˆ…

Last value chacked against threshold value

Table 224. Indexes

Name

Type

Fields

idx_thresholds_sequence

NORMAL

sequence_number

idx_thresholds_item_id

NORMAL

item_id

thresholds_pkey

UNIQUE

threshold_id

TRUSTED_NODES

Trusted nodes - used for cross-node data collection. Source object is an object providing data (it can be node or condition), and target node is a node owning DCI.

Table 225. Columns

Name

Type

State

Default

Description

πŸ”‘source_object_id

INTEGER

NOT NULL

βˆ…

Object id from OBJECT_PROPERTIES

πŸ”‘target_node_id

INTEGER

NOT NULL

βˆ…

Object id from OBJECT_PROPERTIES

Table 226. Indexes

Name

Type

Fields

trusted_nodes_pkey

UNIQUE

source_object_id,target_node_id

USER_GROUP_MEMBERS

Users and group relationships

Table 227. Columns

Name

Type

State

Default

Description

πŸ”‘group_id

INTEGER

NOT NULL

βˆ…

Group id from user_groups table

πŸ”‘user_id

INTEGER

NOT NULL

βˆ…

User id from users table

Table 228. Indexes

Name

Type

Fields

user_group_members_pkey

UNIQUE

group_id,user_id

USER_GROUPS

System user groups

Table 229. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Group id

guid

VARCHAR(36)

NOT NULL

βˆ…

Group GUID

name

VARCHAR(63)

NOT NULL

βˆ…

Group name

system_access

BIGINT

NOT NULL

βˆ…

Bit-mask of system access rights

flags

INTEGER

NOT NULL

βˆ…

Flags:

  • 0x0001 - UF_MODIFIED

  • 0x0002 - UF_DELETED

  • 0x0004 - UF_DISABLED

  • 0x0008 - UF_CHANGE_PASSWORD

  • 0x0010 - UF_CANNOT_CHANGE_PASSWORD

  • 0x0020 - UF_INTRUDER_LOCKOUT

  • 0x0040 - UF_PASSWORD_NEVER_EXPIRES

  • 0x0080 - UF_LDAP_USER

  • 0x0100 - UF_SYNC_EXCEPTION

  • 0x0200 - UF_CLOSE_OTHER_SESSIONS

description

VARCHAR(255)

NULL

βˆ…

Description

ldap_dn

TEXT

NULL

βˆ…

LDAP dn

ldap_unique_id

VARCHAR(64)

NULL

βˆ…

LDAP unique id if field set

Table 230. Indexes

Name

Type

Fields

user_groups_pkey

UNIQUE

id

USER_PROFILES

User variables

Table 231. Columns

Name

Type

State

Default

Description

πŸ”‘user_id

INTEGER

NOT NULL

βˆ…

user id form USERS

πŸ”‘var_name

VARCHAR(255)

NOT NULL

βˆ…

Variable name

var_value

TEXT

NOT NULL

βˆ…

Variable value

Table 232. Indexes

Name

Type

Fields

user_profiles_pkey

UNIQUE

user_id,var_name

USERDB_CUSTOM_ATTRIBUTES

Custom attributes for user database objects

Table 233. Columns

Name

Type

State

Default

Description

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Object id form USERS

πŸ”‘attr_name

VARCHAR(255)

NOT NULL

βˆ…

Attribute name

attr_value

TEXT

NOT NULL

βˆ…

Attribute value

Table 234. Indexes

Name

Type

Fields

userdb_custom_attributes_pkey

UNIQUE

object_id,attr_name

USERS

System users

Table 235. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

User id

guid

VARCHAR(36)

NOT NULL

βˆ…

User guid

name

VARCHAR(63)

NOT NULL

βˆ…

Login name

password

VARCHAR(127)

NOT NULL

βˆ…

Hashed password

system_access

BIGINT

NOT NULL

βˆ…

Bit-mask of system access rights

flags

INTEGER

NOT NULL

βˆ…

Account flags (locked, password never expire etc.)

full_name

VARCHAR(127)

NULL

βˆ…

Full name

description

VARCHAR(255)

NULL

βˆ…

Description

grace_logins

INTEGER

NOT NULL

βˆ…

Number of grace logins

auth_method

INTEGER

NOT NULL

βˆ…

Authentication method:

  • 0 - AUTH_NETXMS_PASSWORD

  • 1 - AUTH_RADIUS

  • 2 - AUTH_CERTIFICATE

  • 3 - AUTH_CERT_OR_PASSWD

  • 4 - AUTH_CERT_OR_RADIUS

cert_mapping_method

INTEGER

NOT NULL

βˆ…

Certifiacte mapping method:

  • 0 - USER_MAP_CERT_BY_SUBJECT

  • 1 - USER_MAP_CERT_BY_PUBKEY

  • 2 - USER_MAP_CERT_BY_CN

cert_mapping_data

TEXT

NULL

βˆ…

Certificate mapping data

auth_failures

INTEGER

NOT NULL

βˆ…

Number of authentication failures

last_passwd_change

INTEGER

NOT NULL

βˆ…

Date of last password change (UNIX timestamp)

min_passwd_length

INTEGER

NOT NULL

βˆ…

Minimal password lenght

disabled_until

INTEGER

NOT NULL

βˆ…

Timesamp till what date user is disabled (UNIX timestamp)

last_login

INTEGER

NOT NULL

βˆ…

Last login time (UNIX timestamp)

password_history

TEXT

NULL

βˆ…

Password history

xmpp_id

VARCHAR(127)

NULL

βˆ…

XMPP id

ldap_dn

TEXT

NULL

βˆ…

LDAP dn

ldap_unique_id

VARCHAR(64)

NULL

βˆ…

LDAP unique id if field set

Table 236. Indexes

Name

Type

Fields

users_pkey

UNIQUE

id

USM_CREDENTIALS

Default SNMP v3 USM credentials

Table 237. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

SNMP v3 USM credential unique identifier

user_name

VARCHAR(255)

NOT NULL

βˆ…

SNMP v3 USM username

auth_method

INTEGER

NOT NULL

βˆ…

SNMP v3 USM authentication method

priv_method

INTEGER

NOT NULL

βˆ…

SNMP v3 USM encryption method

auth_password

VARCHAR(255)

NULL

βˆ…

SNMP v3 USM authentication password

priv_password

VARCHAR(255)

NULL

βˆ…

SNMP v3 USM encryption password

Table 238. Indexes

Name

Type

Fields

usm_credentials_pkey

UNIQUE

id

VPN_CONNECTOR_NETWORKS

VPN connector networks

Table 239. Columns

Name

Type

State

Default

Description

πŸ”‘vpn_id

INTEGER

NOT NULL

βˆ…

VPN unique id from OBJECT_PROPERTIES

network_type

INTEGER

NOT NULL

βˆ…

Network type

  • 0 - local

  • 1 - remote

πŸ”‘ip_addr

VARCHAR(48)

NOT NULL

βˆ…

IP address

ip_netmask

INTEGER

NOT NULL

βˆ…

Network mask

Table 240. Indexes

Name

Type

Fields

vpn_connector_networks_pkey

UNIQUE

vpn_id,ip_addr

VPN_CONNECTORS

VPN connectors

Table 241. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

node_id

INTEGER

NOT NULL

βˆ…

Node id from NODES

peer_gateway

INTEGER

NOT NULL

βˆ…

Peer gateway. Id form NODES

Table 242. Indexes

Name

Type

Fields

vpn_connectors_pkey

UNIQUE

id

ZMQ_SUBSCRIPTION

ZMQ Subscriptions

Table 243. Columns

Name

Type

State

Default

Description

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Object id form OBJECT_PROPERTIES

πŸ”‘subscription_type

CHAR(1)

NOT NULL

βˆ…

Subscription type:

  • E - DB_TYPE_EVENT

  • D - DB_TYPE_DATA

ignore_items

INTEGER

NOT NULL

βˆ…

Boolean flag if items should be ignored

items

TEXT

NULL

βˆ…

Coma separated item list

Table 244. Indexes

Name

Type

Fields

zmq_subscription_pkey

UNIQUE

object_id,subscription_type

ZONE_PROXIES

Zones proxy list

Table 245. Columns

Name

Type

State

Default

Description

πŸ”‘object_id

INTEGER

NOT NULL

βˆ…

Zone id from ZONES

proxy_node

INTEGER

NOT NULL

βˆ…

Proxy node id from NODES

Table 246. Indexes

Name

Type

Fields

zone_proxies_pkey

UNIQUE

object_id,proxy_node

ZONES

Zones

Table 247. Columns

Name

Type

State

Default

Description

πŸ”‘id

INTEGER

NOT NULL

βˆ…

Zone id from OBJECT_PROPERTIES

zone_guid

INTEGER

NOT NULL

βˆ…

Zone GUID

Table 248. Indexes

Name

Type

Fields

zones_pkey

UNIQUE

id