You can download offline version here here.
Introduction
TBD
Tables
ACCESS_POINTS
List of known access points, as collected from wireless controllers.
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 |
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 |
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.
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:
|
Name |
Type |
Fields |
acl_pkey |
UNIQUE |
object_id,user_id |
ACTIONS
Server actions used in event processing.
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:
|
is_disabled |
INTEGER |
NOT NULL |
β |
State of the action:
|
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 |
Name |
Type |
Fields |
actions_pkey |
UNIQUE |
action_id |
ADDRESS_LISTS
List of network ranges and subnets used by network discovery.
Name |
Type |
State |
Default |
Description |
πlist_type |
INTEGER |
NOT NULL |
β |
Purpose of the record:
|
πcommunity_id |
INTEGER |
NOT NULL |
β |
Reserved for future use |
πaddr_type |
INTEGER |
NOT NULL |
β |
Type of the record:
|
π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 |
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.
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. |
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.
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. |
Name |
Type |
Fields |
agent_pkg_pkey |
UNIQUE |
pkg_id |
ALARM_CATEGORIES
Alarm categories
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Category ID |
name |
VARCHAR(63) |
NULL |
β |
Category name |
descr |
VARCHAR(255) |
NULL |
β |
Category description |
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.
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. |
Name |
Type |
Fields |
alarm_category_acl_pkey |
UNIQUE |
category_id,user_id |
ALARM_CATEGORY_MAP
Relation between alarms and alarm categories.
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. |
Name |
Type |
Fields |
alarm_category_map_pkey |
UNIQUE |
alarm_id,category_id |
ALARM_EVENTS
History of all events which resulted in generating alarm.
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 |
β |
|
event_timestamp |
INTEGER |
NOT NULL |
β |
Unix time stamp of the event. |
message |
VARCHAR(2000) |
NULL |
β |
Event message. |
Name |
Type |
Fields |
idx_alarm_events_alarm_id |
NORMAL |
alarm_id |
alarm_events_pkey |
UNIQUE |
alarm_id,event_id |
ALARM_NOTES
Alarm comments.
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. |
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.
Name |
Type |
State |
Default |
Description |
πalarm_id |
INTEGER |
NOT NULL |
β |
Unique identifier. |
alarm_state |
INTEGER |
NOT NULL |
β |
State of the alarm:
|
hd_state |
INTEGER |
NOT NULL |
β |
State of the related helpdesk ticket (if any):
|
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_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 |
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 |
repeat_count |
INTEGER |
NOT NULL |
β |
Number of repeated events with the same |
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 |
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 |
Name |
Type |
Fields |
alarms_pkey |
UNIQUE |
alarm_id |
AP_BINDINGS
Agent policies to node binding
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 |
Name |
Type |
Fields |
ap_bindings_pkey |
UNIQUE |
policy_id,node_id |
AP_COMMON
Agent policies common attributes
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 |
Name |
Type |
Fields |
ap_common_pkey |
UNIQUE |
id |
AP_CONFIG_FILES
Agent policies configuration files
Name |
Type |
State |
Default |
Description |
πpolicy_id |
INTEGER |
NOT NULL |
β |
Unique policy identifier from AP_COMMON |
file_content |
TEXT |
NULL |
β |
Policy file content |
Name |
Type |
Fields |
ap_config_files_pkey |
UNIQUE |
policy_id |
AP_LOG_PARSER
Agent policies log parser files
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 |
Name |
Type |
Fields |
ap_log_parser_pkey |
UNIQUE |
policy_id |
AUDIT_LOG
Log of all user actions.
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 |
Name |
Type |
Fields |
audit_log_pkey |
UNIQUE |
record_id |
BUSINESS_SERVICES
Business services for defining SLA.
Name |
Type |
State |
Default |
Description |
πservice_id |
INTEGER |
NOT NULL |
β |
Unique identifier from OBJECT_PROPERTIES |
Name |
Type |
Fields |
business_services_pkey |
UNIQUE |
service_id |
CERTIFICTE_ACTION_LOG
Certificate activity log
Name |
Type |
State |
Default |
Description |
πrecord_id |
INTEGER |
NOT NULL |
β |
Record primary key |
timestamp |
INTEGER |
NOT NULL |
β |
Action timestamp |
operation |
INTEGER |
NOT NULL |
β |
Operation:
|
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:
|
subject |
VARCHAR(36) |
NULL |
β |
Subject |
serial |
VARCHAR(36) |
NULL |
β |
Serial |
Name |
Type |
Fields |
certificate_action_log_pkey |
UNIQUE |
record_id |
CERTIFICATES
Storage for x509 certificates used for authentication.
Name |
Type |
State |
Default |
Description |
πcert_id |
INTEGER |
NOT NULL |
β |
Unique identifier |
cert_type |
INTEGER |
NOT NULL |
β |
Type of the certificate. Known values:
|
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. |
Name |
Type |
Fields |
certificates_pkey |
UNIQUE |
cert_id |
CHASSIS
Chassis
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:
|
rack_image_rear |
VARCHAR(36) |
NOT NULL |
β |
Image GUID to be used in rear rack view |
Name |
Type |
Fields |
chassis_pkey |
UNIQUE |
id |
CLUSTER_MEMBERS
Cluster members
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. |
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.
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. |
Name |
Type |
Fields |
cluster_resources_pkey |
UNIQUE |
cluster_id,resource_id |
CLUSTER_SYNC_SUBNETS
Cluster subnets used for interconnect.
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). |
Name |
Type |
Fields |
cluster_sync_subnets_pkey |
UNIQUE |
cluster_id,subnet_addr |
CLUSTERS
Information specific for Cluster objects.
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. |
Name |
Type |
Fields |
clusters_pkey |
UNIQUE |
id |
COND_DCI_MAP
Mapping of the conditions to corresponding data collection items.
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:
|
num_polls |
INTEGER |
NOT NULL |
β |
Number of values for |
Name |
Type |
Fields |
cond_dci_map_pkey |
UNIQUE |
condition_id,sequence_number |
CONDITIONS
Conditions definition table.
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 |
β |
|
active_status |
INTEGER |
NOT NULL |
β |
Condition active status:
|
inactive_status |
INTEGER |
NOT NULL |
β |
Condition inactive status:
|
script |
TEXT |
NOT NULL |
β |
NXSL script for activating condition. |
Name |
Type |
Fields |
conditions_pkey |
UNIQUE |
id |
CONFIG_CLOB
System configuration table for large data elements
Name |
Type |
State |
Default |
Description |
πvar_name |
VARCHAR(63) |
NOT NULL |
β |
Parameter name |
var_value |
TEXT |
NULL |
β |
Value |
Name |
Type |
Fields |
config_clob_pkey |
UNIQUE |
var_name |
CONFIG_REPOSITORIES
Repository configuration for templates market.
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. |
Name |
Type |
Fields |
config_repositories_pkey |
UNIQUE |
id |
CONFIG_VALUES
Possible values for system configuration parameters. Used by the GUI only.
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 |
Name |
Type |
Fields |
config_values_pkey |
UNIQUE |
var_name,var_value |
CONFIG
Server configuration.
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:
|
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. |
Name |
Type |
Fields |
config_pkey |
UNIQUE |
var_name |
CONTAINER_MEMBERS
Parent-child relations between containers and objects inside them.
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). |
Name |
Type |
Fields |
container_members_pkey |
UNIQUE |
container_id,object_id |
COUNTRY_CODES
List of country codes
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 |
Name |
Type |
Fields |
country_codes_pkey |
UNIQUE |
numeric_code |
CURRENCY_CODES
List of currency codes
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 |
Name |
Type |
Fields |
currency_codes_pkey |
UNIQUE |
numeric_code |
DASHBOARD_ASSOCIATIONS
Associations between dashboards and other objects
Name |
Type |
State |
Default |
Description |
πobject_id |
INTEGER |
NOT NULL |
β |
Object id from OBJECT_PROPERTIES |
πdashboard_id |
INTEGER |
NOT NULL |
β |
Dashboard id from DASHBOARDS |
Name |
Type |
Fields |
dashboard_associations_pkey |
UNIQUE |
object_id,dashboard_id |
DASHBOARD_ELEMENTS
Widgets and layout configuration of each dashboard.
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:
|
element_data |
TEXT |
NULL |
β |
Widget configuration (data sources, etc.). Format is internal to a widget. |
layout_data |
TEXT |
NULL |
β |
Widget layout details. |
Name |
Type |
Fields |
dashboard_elements_pkey |
UNIQUE |
dashboard_id,element_id |
DASHBOARDS
List of all dashboards.
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:
|
Name |
Type |
Fields |
dashboards_pkey |
UNIQUE |
id |
DC_TABLE_COLUMNS
Data collection configuration for table items βΒ column configuration.
Name |
Type |
State |
Default |
Description |
πtable_id |
INTEGER |
NOT NULL |
β |
Reference to |
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:
|
display_name |
VARCHAR(255) |
NULL |
β |
Column name to be shown to user. |
Name |
Type |
Fields |
dc_table_columns_pkey |
UNIQUE |
table_id,column_name |
DC_TABLES
Data collection configuration for table items.
Name |
Type |
State |
Default |
Description |
πitem_id |
INTEGER |
NOT NULL |
β |
Unique identifier. |
node_id |
INTEGER |
NOT NULL |
β |
|
template_id |
INTEGER |
NOT NULL |
β |
ID of the source template. If item was created directly on the node, value will be |
template_item_id |
INTEGER |
NOT NULL |
β |
ID of the DCI in the template. If item was created directly on the node, value will be |
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:
|
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 |
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:
|
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
|
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 |
Name |
Type |
Fields |
idx_dc_tables_node_id |
NORMAL |
node_id |
dc_tables_pkey |
UNIQUE |
item_id |
DCI_ACCESS
Access rights for dci
Name |
Type |
State |
Default |
Description |
πdci_id |
INTEGER |
NOT NULL |
β |
|
πuser_id |
INTEGER |
NOT NULL |
β |
User id from USERS |
Name |
Type |
Fields |
dci_access_pkey |
UNIQUE |
dci_id,user_id |
DCI_SCHEDULES
Advanced schedules for DCI.
Name |
Type |
State |
Default |
Description |
πschedule_id |
INTEGER |
NOT NULL |
β |
Unique identifier. |
πitem_id |
INTEGER |
NOT NULL |
β |
|
schedule |
VARCHAR(255) |
NULL |
β |
Cron-like schedule definition. |
Name |
Type |
Fields |
dci_schedules_pkey |
UNIQUE |
item_id,schedule_id |
DCI_SUMMARY_TABLES
Configuration of DCI summary tables.
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:
|
columns |
VARCHAR(255) |
NULL |
β |
Columns configuration. |
table_dci_name |
TEXT |
NULL |
β |
Name of the summary table. |
Name |
Type |
Fields |
dci_summary_tables_pkey |
UNIQUE |
id |
DCT_THREASHOLD_INSTANCES
Table stores matched instances by table threashold
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 |
Name |
Type |
Fields |
dct_threashold_instances_pkey |
UNIQUE |
threshold_id,instance,maint_copy |
DCT_COLUMN_NAMES
Data collection configuration for table items - column names.
Name |
Type |
State |
Default |
Description |
πcolumn_id |
INTEGER |
NOT NULL |
β |
Unique identifier. |
column_name |
VARCHAR(63) |
NOT NULL |
β |
Name of the column. |
Name |
Type |
Fields |
dct_column_names_pkey |
UNIQUE |
column_id |
DCT_NODE_MAP
Mapping between nodes and applied templates with table DCI.
Name |
Type |
State |
Default |
Description |
πtemplate_id |
INTEGER |
NOT NULL |
β |
Templade ID. Reference to TEMPLATES. |
πnode_id |
INTEGER |
NOT NULL |
β |
Name |
Type |
Fields |
dct_node_map_pkey |
UNIQUE |
template_id,node_id |
DCT_THRESHOLD_CONDITIONS
Table threshold conditions
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:
|
check_value |
VARCHAR(255) |
NULL |
β |
Check value |
Name |
Type |
Fields |
dct_threshold_conditions_pkey |
UNIQUE |
threshold_id,group_id,sequence_number |
DCT_THRESHOLDS
Table threshold configuration
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 |
Name |
Type |
Fields |
dct_thresholds_pkey |
UNIQUE |
id |
EVENT_CFG
Event templates
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 |
Name |
Type |
Fields |
event_cfg_pkey |
UNIQUE |
event_code |
EVENT_GROUP_MEMBERS
Reserved for future use.
Name |
Type |
State |
Default |
Description |
πgroup_id |
INTEGER |
NOT NULL |
β |
|
πevent_code |
INTEGER |
NOT NULL |
β |
Name |
Type |
Fields |
event_group_members_pkey |
UNIQUE |
group_id,event_code |
EVENT_GROUPS
Reserved for future use.
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 |
β |
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.
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 |
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 |
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.
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 |
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 |
β |
Name |
Type |
Fields |
event_policy_pkey |
UNIQUE |
rule_id |
GRAPH_ACL
Access control table for saved graphs.
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:
|
Name |
Type |
Fields |
graph_acl_pkey |
UNIQUE |
graph_id,user_id |
GRAPHS
Saved graphs.
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 |
β |
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.
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. |
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.
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. |
Name |
Type |
Fields |
idata_key |
NORMAL |
node_id,item_id,idata_timestamp |
IMAGES
Meta-data for image library.
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. |
Name |
Type |
Fields |
images_name_category_key |
UNIQUE |
name,category |
images_pkey |
UNIQUE |
guid |
INTERFACE_ADDRESS_LIST
Interface IP addresses
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 |
Name |
Type |
Fields |
interface_address_list_pkey |
UNIQUE |
iface_id,ip_addr |
INTERFACE_VLAN_LIST
Vlan to interface connection
Name |
Type |
State |
Default |
Description |
πiface_id |
INTEGER |
NOT NULL |
β |
Interface id from INTERFACES |
πvlan_id |
INTEGER |
NOT NULL |
β |
Vlan id |
Name |
Type |
Fields |
interface_vlan_list_pkey |
UNIQUE |
iface_id,vlan_id |
INTERFACES
Interface information
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_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:
|
oper_state |
INTEGER |
NOT NULL |
β |
Interface operational states:
|
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 |
Name |
Type |
Fields |
interfaces_pkey |
UNIQUE |
id |
ITEMS
Data collection configuration for signle-value items.
Name |
Type |
State |
Default |
Description |
πitem_id |
INTEGER |
NOT NULL |
β |
Unique identifier. |
node_id |
INTEGER |
NOT NULL |
β |
|
template_id |
INTEGER |
NOT NULL |
β |
ID of the source template. If item was created directly on the node, value will be |
template_item_id |
INTEGER |
NOT NULL |
β |
ID of the DCI in the template. If item was created directly on the node, value will be |
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:
|
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 |
snmp_port |
INTEGER |
NOT NULL |
β |
SNMP port. |
datatype |
INTEGER |
NOT NULL |
β |
Type of data:
|
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:
|
snmp_raw_value_type |
INTEGER |
NOT NULL |
β |
SNMP raw value type:
|
delta_calculation |
INTEGER |
NOT NULL |
β |
Delta calculation methods for DCI:
|
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:
|
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:
|
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 |
Name |
Type |
Fields |
idx_items_node_id |
NORMAL |
node_id |
items_pkey |
UNIQUE |
item_id |
JOB_HISTORY
Server job history table
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:
|
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:
|
failure_message |
VARCHAR(255) |
NULL |
β |
Description of fail |
Name |
Type |
Fields |
job_history_pkey |
UNIQUE |
id |
LICENSES
License repository
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
License unique identifier |
content |
TEXT |
NULL |
β |
License content |
Name |
Type |
Fields |
licenses_pkey |
UNIQUE |
id |
MAPPING_DATA
Mapping tables content
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 |
Name |
Type |
Fields |
mapping_data_pkey |
UNIQUE |
table_id,md_key |
MAPPING_TABLES
Mapping tables
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:
|
description |
VARCHAR(4000) |
NULL |
β |
Mapping table description |
Name |
Type |
Fields |
mapping_tables_pkey |
UNIQUE |
id |
METADATA
System meta data (DBMS type, schema version, etc.)
Name |
Type |
State |
Default |
Description |
πvar_name |
VARCHAR(63) |
NOT NULL |
β |
Variable name |
var_value |
VARCHAR(255) |
NOT NULL |
β |
Variable value |
Name |
Type |
Fields |
metadata_pkey |
UNIQUE |
var_name |
MOBILE_DEVICES
Mobile devices from object_properties
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 |
Name |
Type |
Fields |
mobile_devices_pkey |
UNIQUE |
id |
NETWORK_MAP_ELEMENTS
Elements of network maps
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:
|
element_data |
TEXT |
NOT NULL |
β |
Element data in XML format |
flags |
INTEGER |
NOT NULL |
β |
Network map element flags. Currently there are no flags defined. |
Name |
Type |
Fields |
network_map_elements_pkey |
UNIQUE |
map_id,element_id |
NETWORK_MAP_LINKS
Links on network maps
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:
|
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. |
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.
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 |
Name |
Type |
Fields |
network_map_seed_nodes_pkey |
UNIQUE |
map_id,seed_node_id |
NETWORK_MAPS
Network maps
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:
|
layout |
INTEGER |
NOT NULL |
β |
Network map layout:
|
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:
|
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:
|
object_display_mode |
INTEGER |
NOT NULL |
β |
Object display mode:
|
filter |
TEXT |
NULL |
β |
Network map NXSL object filter for automatic maps |
Name |
Type |
Fields |
network_maps_pkey |
UNIQUE |
id |
NETWORK_SERVICES
Network services
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:
|
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 |
Name |
Type |
Fields |
network_services_pkey |
UNIQUE |
id |
NODE_COMPONENTS
Node hardware components retrieved using Entity MIB.
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.
|
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. |
Name |
Type |
Fields |
node_components_pkey |
UNIQUE |
node_id, component_index |
NODE_LINKS
SLA node links
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 |
Name |
Type |
Fields |
node_links_pkey |
UNIQUE |
nodelink_id |
NODES
Nodes
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:
|
runtime_flags |
INTEGER |
NOT NULL |
β |
Runtime flags:
|
snmp_version |
INTEGER |
NOT NULL |
β |
SNMP version
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
hypervisor_info |
VARCHAR(255) |
NULL |
β |
Hypervisor info that might be or might not be. There can be some version information. |
Name |
Type |
Fields |
nodes_pkey |
UNIQUE |
id |
NSMAP
Nodes to subnets mapping
Name |
Type |
State |
Default |
Description |
πsubnet_id |
INTEGER |
NOT NULL |
β |
Subnet id from SUBNETS |
πnode_id |
INTEGER |
NOT NULL |
β |
Node id from NODES |
Name |
Type |
Fields |
nsmap_pkey |
UNIQUE |
subnet_id,node_id |
OBJECT_ACCESS_SNAPSHOT
Snapshot for object access rights
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:
|
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.
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier. |
object_class |
INTEGER |
NOT NULL |
β |
Object class:
|
flags |
INTEGER |
NOT NULL |
β |
Flags:
|
auto_bind_filter |
TEXT |
NULL |
β |
NXSL autobind filter script. |
Name |
Type |
Fields |
object_containers_pkey |
UNIQUE |
id |
OBJECT_CUSTOM_ATTRIBUTES
Object custom attributes
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 |
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…)
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:
|
status_prop_alg |
INTEGER |
NOT NULL |
β |
Status propagation algorithms
|
status_fixed_val |
INTEGER |
NOT NULL |
β |
Fixed value for status if SA_PROPAGATE_FIXED propagation algorithms is used. Status options:
|
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:
|
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:
|
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 |
Name |
Type |
Fields |
object_properties_pkey |
UNIQUE |
object_id |
OBJECT_TOOLS_ACL
Access list for object tools
Name |
Type |
State |
Default |
Description |
πtool_id |
INTEGER |
NOT NULL |
β |
Tool id from OBJECT_TOOLS |
πuser_id |
INTEGER |
NOT NULL |
β |
User id form USERS |
Name |
Type |
Fields |
object_tools_acl_pkey |
UNIQUE |
tool_id,user_id |
OBJECT_TOOLS_INPUT_FIELDS
Input fields for object tools
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:
|
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 |
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
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:
|
col_substr |
INTEGER |
NULL |
β |
Number of subsrging generated by regexp defined in OBJECT_TOOLS for this object tool. |
Name |
Type |
Fields |
object_tools_table_columns_pkey |
UNIQUE |
tool_id,col_number |
OBJECT_TOOLS
Object tools
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:
|
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:
|
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 |
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.
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 |
Name |
Type |
Fields |
object_urls_pkey |
UNIQUE |
object_id,url_id |
ORGANIZATIONS
Reserved for future use.
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 |
β |
Name |
Type |
Fields |
organizations_pkey |
UNIQUE |
id |
PERSISTENT_STORAGE
Persistent storage table accessible from EPP and any script
Name |
Type |
State |
Default |
Description |
πentry_key |
VARCHAR(255) |
NOT NULL |
β |
Unique string key |
value |
VARCHAR(2000) |
NULL |
β |
Value |
Name |
Type |
Fields |
persistent_storage_pkey |
UNIQUE |
entry_key |
PERSONS
Reserved for future use.
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 |
β |
Name |
Type |
Fields |
persons_pkey |
UNIQUE |
id |
POLICY_ACTION_LIST
Event processing policy actions
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 |
Name |
Type |
Fields |
policy_action_list_pkey |
UNIQUE |
rule_id,action_id |
POLICY_EVENT_LIST
Event processing policy events
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 |
Name |
Type |
Fields |
policy_event_list_pkey |
UNIQUE |
rule_id,event_code |
POLICY_PSTORAGE_ACTIONS
Table that links epp with persistent storage
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 |
Name |
Type |
Fields |
policy_pstorage_actions_pkey |
UNIQUE |
rule_id,ps_key,action |
POLICY_SOURCE_LIST
Event processing policy source objects
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 |
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
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 |
Name |
Type |
Fields |
policy_timer_cancellation_list_pkey |
UNIQUE |
rule_id,timer_key |
PORT_LAYOUTS
List of possible port layout options
Name |
Type |
State |
Default |
Description |
πdevice_oid |
VARCHAR(255) |
NOT NULL |
β |
Device OID |
numbering_scheme |
CHAR(1) |
NOT NULL |
β |
Numbering scheme
|
row_count |
CHAR(1) |
NULL |
β |
Number of rows |
layout_data |
VARCHAR(4000) |
NULL |
β |
Custom layout data. Reserved for future use. |
Name |
Type |
Fields |
port_layouts_pkey |
UNIQUE |
device_oid |
RACKS
Racks
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 |
Name |
Type |
Fields |
racks_pkey |
UNIQUE |
id |
RAW_DCI_VALUES
Last collected DCI values
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) |
Name |
Type |
Fields |
raw_dci_values_pkey |
UNIQUE |
item_id |
SCHEDULED_TASKS
Scheduled task information
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier. |
taskid |
VARCHAR(255) |
NULL |
β |
Task type. Known types:
|
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:
|
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 |
Name |
Type |
Fields |
scheduled_tasks_pkey |
UNIQUE |
id |
SCRIPT_LIBRARY
Script library
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 |
Name |
Type |
Fields |
script_library_pkey |
UNIQUE |
script_id |
SLM_AGREEMENTS
SLA - agreements. Reserved for future use.
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 |
Name |
Type |
Fields |
slm_agreements_pkey |
UNIQUE |
agreement_id |
SLM_CHECKS
SLA service checks
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique SLM check |
type |
INTEGER |
NOT NULL |
β |
Type:
|
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 |
Name |
Type |
Fields |
slm_checks_pkey |
UNIQUE |
id |
SLM_SERVICE_HISTORY
SLA service change log
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:
|
Name |
Type |
Fields |
slm_service_history_pkey |
UNIQUE |
record_id |
SLM_TICKETS
SLA tickets
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 |
Name |
Type |
Fields |
slm_tickets_pkey |
UNIQUE |
ticket_id |
SNMP_COMMUNITIES
List of possible community strings
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique comunity id |
community |
VARCHAR(255) |
NULL |
β |
SNMP comunity |
Name |
Type |
Fields |
snmp_communities_pkey |
UNIQUE |
id |
SNMP_TRAP_CFG
SNMP trap configuration
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 |
Name |
Type |
Fields |
snmp_trap_cfg_pkey |
UNIQUE |
trap_id |
SNMP_TRAP_LOG
Extended SNMP trap log
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 |
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
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:
|
snmp_oid |
VARCHAR(255) |
NULL |
β |
SNMP trap oid |
description |
VARCHAR(255) |
NULL |
β |
Description |
Name |
Type |
Fields |
snmp_trap_pmap_pkey |
UNIQUE |
trap_id,parameter |
SUBNETS
Subnets
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 |
Name |
Type |
Fields |
subnets_pkey |
UNIQUE |
id |
SYSLOG
Stored syslog messages
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 |
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.
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. |
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.
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. |
Name |
Type |
Fields |
tdata_key |
NORMAL |
node_id,item_id,tdata_timestamp |
TEMPLATES
Data collection templates
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier |
version |
INTEGER |
NOT NULL |
β |
Template version |
flags |
INTEGER |
NOT NULL |
β |
Template flags:
|
apply_filter |
TEXT |
NULL |
β |
NXSL template auto apply script. |
Name |
Type |
Fields |
templates_pkey |
UNIQUE |
id |
THRESHOLDS
Threshold checking rules
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:
|
check_operation |
INTEGER |
NOT NULL |
β |
Threshold operations:
|
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 |
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.
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 |
Name |
Type |
Fields |
trusted_nodes_pkey |
UNIQUE |
source_object_id,target_node_id |
USER_GROUP_MEMBERS
Users and group relationships
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 |
Name |
Type |
Fields |
user_group_members_pkey |
UNIQUE |
group_id,user_id |
USER_GROUPS
System user groups
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:
|
description |
VARCHAR(255) |
NULL |
β |
Description |
ldap_dn |
TEXT |
NULL |
β |
LDAP dn |
ldap_unique_id |
VARCHAR(64) |
NULL |
β |
LDAP unique id if field set |
Name |
Type |
Fields |
user_groups_pkey |
UNIQUE |
id |
USER_PROFILES
User variables
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 |
Name |
Type |
Fields |
user_profiles_pkey |
UNIQUE |
user_id,var_name |
USERDB_CUSTOM_ATTRIBUTES
Custom attributes for user database objects
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 |
Name |
Type |
Fields |
userdb_custom_attributes_pkey |
UNIQUE |
object_id,attr_name |
USERS
System users
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:
|
cert_mapping_method |
INTEGER |
NOT NULL |
β |
Certifiacte mapping method:
|
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 |
Name |
Type |
Fields |
users_pkey |
UNIQUE |
id |
USM_CREDENTIALS
Default SNMP v3 USM credentials
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 |
Name |
Type |
Fields |
usm_credentials_pkey |
UNIQUE |
id |
VPN_CONNECTOR_NETWORKS
VPN connector networks
Name |
Type |
State |
Default |
Description |
πvpn_id |
INTEGER |
NOT NULL |
β |
VPN unique id from OBJECT_PROPERTIES |
network_type |
INTEGER |
NOT NULL |
β |
Network type
|
πip_addr |
VARCHAR(48) |
NOT NULL |
β |
IP address |
ip_netmask |
INTEGER |
NOT NULL |
β |
Network mask |
Name |
Type |
Fields |
vpn_connector_networks_pkey |
UNIQUE |
vpn_id,ip_addr |
VPN_CONNECTORS
VPN connectors
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Vpn id form [vpn-connector-networks] |
node_id |
INTEGER |
NOT NULL |
β |
Node id from NODES |
peer_gateway |
INTEGER |
NOT NULL |
β |
Peer gateway. Id form NODES |
Name |
Type |
Fields |
vpn_connectors_pkey |
UNIQUE |
id |
ZMQ_SUBSCRIPTION
ZMQ Subscriptions
Name |
Type |
State |
Default |
Description |
πobject_id |
INTEGER |
NOT NULL |
β |
Object id form OBJECT_PROPERTIES |
πsubscription_type |
CHAR(1) |
NOT NULL |
β |
Subscription type:
|
ignore_items |
INTEGER |
NOT NULL |
β |
Boolean flag if items should be ignored |
items |
TEXT |
NULL |
β |
Coma separated item list |
Name |
Type |
Fields |
zmq_subscription_pkey |
UNIQUE |
object_id,subscription_type |
ZONE_PROXIES
Zones proxy list
Name |
Type |
State |
Default |
Description |
πobject_id |
INTEGER |
NOT NULL |
β |
Zone id from ZONES |
proxy_node |
INTEGER |
NOT NULL |
β |
Proxy node id from NODES |
Name |
Type |
Fields |
zone_proxies_pkey |
UNIQUE |
object_id,proxy_node |
ZONES
Zones
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Zone id from OBJECT_PROPERTIES |
zone_guid |
INTEGER |
NOT NULL |
β |
Zone GUID |
Name |
Type |
Fields |
zones_pkey |
UNIQUE |
id |