Download PDF for offline use.
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 |
channel_name |
VARCHAR(36) |
NULL |
β |
Notification channel name |
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 |
comments |
VARCHAR(255) |
NULL |
β |
Comment to credential entry |
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. |
agent_pkg |
VARCHAR(15) |
NULL |
β |
Package type:
|
command |
VARCHAR(255) |
NULL |
β |
Command to install package |
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 |
ALARM_STATE_CHANGES
Log of alarm state changes.
Name |
Type |
State |
Default |
Description |
πrecord_id |
BIGINT |
NOT NULL |
β |
Unique identifier. |
alarm_id |
INTEGER |
NOT NULL |
β |
ID of the alarm. Reference to ALARMS. |
prev_state |
INTEGER |
NOT NULL |
β |
Previous state:
|
new_state |
INTEGER |
NOT NULL |
β |
New state state:
|
change_time |
INTEGER |
NOT NULL |
β |
Unix time stamp of change. |
prev_state_duration |
INTEGER |
NOT NULL |
β |
Previous state duration in seconds. |
change_by |
INTEGER |
NOT NULL |
β |
User id that made state change USERS |
Name |
Type |
Fields |
idx_alarm_state_changes_by_id |
NORMAL |
alarm_id |
alarm_state_changes_pkey |
UNIQUE |
record_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 |
NOT NULL |
β |
Zone unique identification number from ZONES |
rule_guid |
VARCHAR(36) |
NULL |
β |
Alarm key. |
event_tags |
VARCHAR(2000) |
NULL |
β |
Coma separated event tag list |
parent_alarm_id |
INTEGER |
NOT NULL |
β |
ID of the parent alarm ALARMS |
rca_script_name |
VARCHAR(255) |
NULL |
β |
Name of the root cause analysis script. |
impact |
VARCHAR(1000) |
NULL |
β |
Alarm impact text. |
rule_description |
VARCHAR(255) |
NULL |
β |
Description of EEP rule that generated this alarm |
last_state_change_time |
INTEGER |
NOT NULL |
β |
Last time alarm changed state |
Name |
Type |
Fields |
alarms_pkey |
UNIQUE |
alarm_id |
Name |
Type |
Fields |
idx_alarms_source_object_id |
NORMAL |
source_object_id |
Name |
Type |
Fields |
idx_alarms_last_change_time |
NORMAL |
last_change_time |
AP_COMMON
Agent policies common attributes
Name |
Type |
State |
Default |
Description |
πguid |
VARCHAR(36) |
NOT NULL |
β |
Unique policy identifier |
policy_name |
VARCHAR(63) |
NOT NULL |
β |
Policy name |
owner_id |
INTEGER |
NOT NULL |
β |
Owning template id from TEMPLATES |
policy_type |
VARCAHR(31) |
NOT NULL |
β |
Policy type:
|
file_content |
TEXT |
NULL |
β |
File content (Agent configuration file content or log parser content…) |
version |
INTEGER |
NOT NULL |
β |
Policy version |
flags |
INTEGER |
NOT NULL |
β |
Flags:
|
Name |
Type |
Fields |
ap_common_pkey |
UNIQUE |
guid |
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 |
value_type |
VARCHAR(1) |
NOT NULL |
β |
Value type for old_value and new_value fields. |
hmac |
VARCHAR(64) |
NOT NULL |
β |
HMAC calculated using all audit log fields. |
Name |
Type |
Fields |
audit_log_pkey |
UNIQUE |
record_id |
AUTO_BIND_TARGET
Auto bind information for objects(Templae, Container objects auto bind information)
Name |
Type |
State |
Default |
Description |
πobject_id |
INTEGER |
NOT NULL |
β |
ID of the object. Reference to TEMPLATES ot OBJECT_CONTAINERS. |
bind_filter_1 |
TEXT |
NULL |
β |
First auto bind NXSL filter |
bind_filter_2 |
TEXT |
NULL |
β |
Second auto bind NXSL filter |
flags |
INTEGER |
NOT NULL |
β |
Bind bit flags:
|
Name |
Type |
Fields |
auto_bind_target_pkey |
UNIQUE |
object_id |
BUSINESS_SERVICE_CHECKS
Business service checks
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier. |
type |
INTEGER |
NOT NULL |
β |
Type:
|
content |
TEXT |
NULL |
β |
NXSL script chack |
current_ticket |
INTEGER |
NOT NULL |
β |
Current ticket |
service_id |
INTEGER |
NOT NULL |
β |
Service id form BUSINESS_SERVICES. |
related_object |
INTEGER |
NOT NULL |
β |
Related object id form OBJECT_PROPERTIES. |
related_dci |
INTEGER |
NOT NULL |
β |
Related DCI id form ITEMS. |
status_threshold |
INTEGER |
NOT NULL |
β |
Object or DCI status threshold. |
description |
VARCHAR(1023) |
NULL |
β |
Description. |
current status of the check |
INTEGER |
NOT NULL |
β |
0 if ok, 4 if failed. |
failure_reason |
VARCHAR(255) |
NULL |
β |
Failure reason. |
prototype_service_id |
INTEGER |
NOT NULL |
β |
Business service id form BUSINESS_SERVICES or business service prototype BUSINESS_SERVICE_PROTOTYPES that auto discovered this check or 0 if created manually. |
prototype_check_id |
INTEGER |
NOT NULL |
β |
Business service check prototype id for BUSINESS_SERVICE_CHECKS |
Name |
Type |
Fields |
business_service_checks_pkey |
UNIQUE |
id |
BUSINESS_SERVICES_DOWNTIME
Business services downtime records.
Name |
Type |
State |
Default |
Description |
πrecord_id |
INTEGER |
NOT NULL |
β |
Unique identifier. |
service_id |
INTEGER |
NOT NULL |
β |
Instance source object from BUSINESS_SERVICES |
from_timestamp |
INTEGER |
NOT NULL |
β |
UNIX timestamp when downtime started |
to_timestamp |
INTEGER |
NOT NULL |
β |
UNIX timestamp when downtime stopped or 0 |
Name |
Type |
Fields |
business_service_downtime_pkey |
UNIQUE |
record_id |
BUSINESS_SERVICE_PROTOTYPES
Business services prototype to create other business services form it.
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier from OBJECT_PROPERTIES |
instance_method |
INTEGER |
NOT NULL |
β |
Instance method:
|
instance_source |
INTEGER |
NOT NULL |
β |
Instance source object from OBJECT_PROPERTIES |
instance_data |
VARCAHR(1023) |
NULL |
β |
Instance data |
instance_filter |
TEXT |
NULL |
β |
Instance NXSL filter |
object_status_threshold |
INTEGER |
NOT NULL |
β |
Default object status threshold for auto discovered object checks. |
dci_status_threshold |
INTEGER |
NOT NULL |
β |
Default DCI status threshold for auto discovered DCI checks. |
Name |
Type |
Fields |
business_service_prototypes_pkey |
UNIQUE |
id |
BUSINESS_SERVICE_TICKETS
Business service tickets opened on failed checks
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 |
check_description |
VARCHAR(255) |
NULL |
β |
Check description |
original_ticket_id |
INTEGER |
NOT NULL |
β |
Original ticket id from BUSINESS_SERVICE_TICKETS |
original_service_id |
INTEGER |
NOT NULL |
β |
Original ticket id from BUSINESS_SERVICES |
Name |
Type |
Fields |
business_service_tickets_pkey |
UNIQUE |
ticket_id |
BUSINESS_SERVICES
Business services for defining SLA.
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier from OBJECT_PROPERTIES |
prototype_id |
INTEGER |
NOT NULL |
β |
Prototype id form BUSINESS_SERVICE_PROTOTYPES or 0 |
instance |
VARCAHR(1023) |
NULL |
β |
Instance |
object_status_threshold |
INTEGER |
NOT NULL |
β |
Default object status threshold for auto discovered object checks. |
dci_status_threshold |
INTEGER |
NOT NULL |
β |
Default DCI status threshold for auto discovered DCI checks. |
Name |
Type |
Fields |
business_services_pkey |
UNIQUE |
id |
CERTIFICTE_ACTION_LOG
Certificate activity log
Name |
Type |
State |
Default |
Description |
πrecord_id |
INTEGER |
NOT NULL |
β |
Record primary key |
operation_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 |
idx_cert_action_log_timestamp |
NORMAL |
operation_timestamp |
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 |
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. |
display_priority |
INTEGER |
NOT NULL |
β |
Priority to display dashboard in object tabs. 0 - for automatic |
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 |
related_object |
INTEGER |
NOT NULL |
β |
Related object |
polling_interval_src |
VARCHAR(255) |
NOT NULL |
β |
Source for polling interval calculation |
retention_time_src |
VARCHAR(255) |
NOT NULL |
β |
Source for retention time calculation |
polling_schedule_type |
CHAR(1) |
NOT NULL |
β |
Polling schedule type:
|
retention_type |
CHAR(1) |
NOT NULL |
β |
Retention type:
|
snmp_version |
INTEGER |
NOT NULL |
β |
SNMP version |
state_flags |
INTEGER |
NOT NULL |
β |
State bit flags:
|
Name |
Type |
Fields |
idx_dc_tables_node_id |
NORMAL |
node_id |
dc_tables_pkey |
UNIQUE |
item_id |
DC_TARGETS
Data collection targets table. Any object capable of data collection will contain record here.
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
ID of the object from OBJECT_PROPERTIES |
geolocation_ctrl_mode |
INTEGER |
NOT NULL |
β |
Control mode for configured geo areas:
|
geo_areas |
VARCHAR(2000) |
NULL |
β |
Coma separated list of geo area ids for this object. |
web_service_proxy |
INTEGER |
NOT NULL |
β |
web service proxy node form NODES |
Name |
Type |
Fields |
dc_targets_pkey |
UNIQUE |
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_DELETE_LIST
List of DCI’s that should be deleted on housekeeper
Name |
Type |
State |
Default |
Description |
π |
INTEGER |
NOT NULL |
β |
Object id. Reference form OBJECT_PROPERTIES. |
πdci_id |
INTEGER |
NOT NULL |
β |
|
type |
CHAR(1) |
NOT NULL |
β |
DCI type. |
Name |
Type |
Fields |
dci_delete_list_pkey |
UNIQUE |
node_id,dci_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 |
tags |
VARCHAR(2000) |
NULL |
β |
Event tags coma separated |
Name |
Type |
Fields |
event_cfg_pkey |
UNIQUE |
event_code |
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. |
zone_uin |
INTEGER |
NULL |
β |
Zone unique identification number form ZONES |
raw_data |
TEXT |
NULL |
β |
Event raw data |
tags |
VARCHAR(2000) |
NULL |
β |
Event tags coma separated |
origin |
INTEGER |
NOT NULL |
β |
Event origin. Possible options:
|
origin_timestamp |
INTEGER |
NOT NULL |
β |
Unix time stamp of the event on origin. |
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. |
filter_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 key generation pattern |
alarm_timeout |
INTEGER |
NOT NULL |
β |
Alarm timeout time |
alarm_timeout_event |
INTEGER |
NOT NULL |
β |
Event generated on alarm timeout |
rca_script_name |
VARCHAR(255) |
NULL |
β |
Name of the root cause analysis script. |
alarm_impact |
VARCHAR(1000) |
NULL |
β |
Alarm impact text. |
action_script |
TEXT |
NULL |
β |
Script thet will be executed as an action for event processing rule. |
Name |
Type |
Fields |
event_policy_pkey |
UNIQUE |
rule_id |
GEO_AREAS
Geo area for device area monitoring.
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier. |
name |
VARCHAR(127) |
NOT NULL |
β |
Area name. |
comments |
TEXT |
NULL |
β |
Text comment. |
configuration |
TEXT |
NULL |
β |
Area border configuration |
Name |
Type |
Fields |
geo_areas_pkey |
UNIQUE |
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 |
HARDWARE_INVENTORY
Node hardware inventory
Name |
Type |
State |
Default |
Description |
πnode_id |
INTEGER |
NOT NULL |
β |
ID of the object. Reference to NODES. |
component_type |
VARCHAR(12) |
NOT NULL |
β |
Component type |
component_index |
INTEGER |
NOT NULL |
β |
Component index |
vendor |
VARCHAR(127) |
NULL |
β |
Component vendor |
model |
VARCHAR(127) |
NULL |
β |
Component model |
capacity |
INTEGER |
NOT NULL |
β |
Access point serial number |
serial_number |
VARCHAR(63) |
NULL |
β |
Component serial number |
part_number |
VARCHAR(63) |
NULL |
β |
Component part number |
Name |
Type |
Fields |
hardware_inventory_pkey |
UNIQUE |
node_id,component_type,component_index |
ICMP_STATISTICS
Node ICMP statistics
Name |
Type |
State |
Default |
Description |
πobject_id |
INTEGER |
NOT NULL |
β |
ID of the node. Reference to NODES. |
poll_target |
VARCHAR(63) |
NOT NULL |
β |
Poll target |
min_response_time |
INTEGER |
NOT NULL |
β |
Target minimal target response time |
max_response_time |
INTEGER |
NOT NULL |
β |
Target maximal response time |
avg_response_time |
INTEGER |
NOT NULL |
β |
Target average response time |
last_response_time |
INTEGER |
NOT NULL |
β |
Target last response time |
sample_count |
INTEGER |
NOT NULL |
β |
Target sample count |
raw_response_times |
TEXT |
NULL |
β |
All raw data for the period in hex. 3 hex numbers for each number. |
Name |
Type |
Fields |
icmp_statistics_pkey |
UNIQUE |
object_id,poll_target |
ICMP_TARGET_ADDRESS_LIST
List of addtitional ping targets for the node
Name |
Type |
State |
Default |
Description |
πnode_id |
INTEGER |
NOT NULL |
β |
ID of the node. Reference to NODES. |
ip_addr |
VARCHAR(48) |
NOT NULL |
β |
IP address |
Name |
Type |
Fields |
icmp_target_address_list_pkey |
UNIQUE |
node_id,ip_addr |
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. Not used when timescale is enabled.
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. |
raw_value |
VARCHAR(255) |
NULL |
β |
Raw 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. Not used when timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
π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. |
Name |
Type |
Fields |
idata_key |
NORMAL |
item_id,idata_timestamp |
IDATA_SC_7
Contains historical values for single-value DCIs with retention time [1 - 7] days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from ITEMS |
πidata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
idata_value |
VARCHAR(255) |
NULL |
β |
Collected value. |
raw_value |
VARCHAR(255) |
NULL |
β |
Raw value. |
Name |
Type |
Fields |
idata_sc_7_key |
NORMAL |
item_id,idata_timestamp |
IDATA_SC_30
Contains historical values for single-value DCIs with retention time (7 - 30] days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from ITEMS |
πidata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
idata_value |
VARCHAR(255) |
NULL |
β |
Collected value. |
raw_value |
VARCHAR(255) |
NULL |
β |
Raw value. |
Name |
Type |
Fields |
idata_sc_30_key |
NORMAL |
item_id,idata_timestamp |
IDATA_SC_90
Contains historical values for single-value DCIs with retention time (30 - 90] days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from ITEMS |
πidata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
idata_value |
VARCHAR(255) |
NULL |
β |
Collected value. |
raw_value |
VARCHAR(255) |
NULL |
β |
Raw value. |
Name |
Type |
Fields |
idata_sc_90_key |
NORMAL |
item_id,idata_timestamp |
IDATA_SC_180
Contains historical values for single-value DCIs with retention time (90 - 180] days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from ITEMS |
πidata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
idata_value |
VARCHAR(255) |
NULL |
β |
Collected value. |
raw_value |
VARCHAR(255) |
NULL |
β |
Raw value. |
Name |
Type |
Fields |
idata_sc_180_key |
NORMAL |
item_id,idata_timestamp |
IDATA_SC_DEFAULT
Contains historical values for single-value DCIs with retention time equal to current default retention time. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from ITEMS |
πidata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
idata_value |
VARCHAR(255) |
NULL |
β |
Collected value. |
raw_value |
VARCHAR(255) |
NULL |
β |
Raw value. |
Name |
Type |
Fields |
idata_sc_default_key |
NORMAL |
item_id,idata_timestamp |
IDATA_SC_OTHER
Contains historical values for single-value DCIs with retention time more than 180 days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from ITEMS |
πidata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
idata_value |
VARCHAR(255) |
NULL |
β |
Collected value. |
raw_value |
VARCHAR(255) |
NULL |
β |
Raw value. |
Name |
Type |
Fields |
idata_sc_other_key |
NORMAL |
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 |
INPUT_FIELDS
Input fields for object tools or object queries
Name |
Type |
State |
Default |
Description |
πowner_id |
INTEGER |
NOT NULL |
β |
Object id from OBJECT_TOOLS or from OBJECT_QUERIES. |
πname |
VARCHAR(31) |
NOT NULL |
β |
Input field name |
πcategory |
CHAR(1) |
NOT NULL |
β |
Input filed category:
|
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 |
flags |
INTEGER |
NOT NULL |
β |
Input field bit flags:
|
Name |
Type |
Fields |
input_fields_pkey |
UNIQUE |
category,owner_id,name |
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 |
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_module |
INTEGER |
NOT NULL |
β |
Physical module |
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 - value of ifDescr for SNMP, equals to name for NetXMS agent |
iftable_suffix |
VARCHAR(127) |
NULL |
β |
SNMP OID suffix in ifTable |
parent_iface |
INTEGER |
NOT NULL |
β |
Interface id from INTERFACES |
phy_chassis |
INTEGER |
NOT NULL |
β |
Physical chassis |
phy_pic |
INTEGER |
NOT NULL |
β |
Physical interface card |
oper_slast_known_oper_statetate |
INTEGER |
NOT NULL |
β |
Last known interface operational states:
|
last_known_admin_state |
INTEGER |
NOT NULL |
β |
Last known Interface administrative states:
|
if_alias |
VARCHAR(255) |
NULL |
β |
Interface alias |
ospf_area |
VARCHAR(15) |
NULL |
β |
OSPF area IP address |
ospf_if_type |
INTEGER |
NOT NULL |
β |
OSPF interface type:
|
ospf_if_state |
INTEGER |
NOT NULL |
β |
OSPF interface state:
|
stp_port_state |
INTEGER |
NOT NULL |
β |
STP port state:
|
if_name |
VARCHAR(255) |
NULL |
β |
Original interface name as received from SNMP or NetXMS agent (before expansion) |
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. |
multiplier |
INTEGER |
NOT NULL |
β |
Multiplier. 0 - for default |
units_name |
VARCHAR(63) |
NULL |
β |
Unit name |
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 |
related_object |
INTEGER |
NOT NULL |
β |
Related object |
polling_interval_src |
VARCHAR(255) |
NOT NULL |
β |
Source for polling interval calculation |
retention_time_src |
VARCHAR(255) |
NOT NULL |
β |
Source for retention time calculation |
polling_schedule_type |
CHAR(1) |
NOT NULL |
β |
Polling schedule type:
|
retention_type |
CHAR(1) |
NOT NULL |
β |
Retention type:
|
snmp_version |
INTEGER |
NOT NULL |
β |
SNMP version |
state_flags |
INTEGER |
NOT NULL |
β |
State bit flags:
|
Name |
Type |
Fields |
idx_items_node_id |
NORMAL |
node_id |
items_pkey |
UNIQUE |
item_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 |
MAINTENANCE_JOURNAL
Maintenance journal
Name |
Type |
State |
Default |
Description |
πrecord_id |
INTEGER |
NOT NULL |
β |
Unique identifier |
object_id |
INTEGER |
NOT NULL |
β |
Object id form NODES |
author |
INTEGER |
NOT NULL |
β |
User id USERS that initiated maintenance. |
last_edited_by |
INTEGER |
NOT NULL |
β |
User id USERS that made last change. |
description |
TEXT |
NULL |
β |
Maintenance reason. |
creation_time |
INTEGER |
NOT NULL |
β |
UNIX timestamp when object entered maintenance |
modification_time |
INTEGER |
NOT NULL |
β |
UNIX timestamp when object maintenance mode last changed |
Name |
Type |
Fields |
maintenance_journal_pkey |
UNIQUE |
record_id |
idx_maintjrn_creation_time |
NORMAL |
creation_time |
idx_maintjrn_object_id |
NORMAL |
object_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(4000) |
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 |
comm_protocol |
VARCHAR(31) |
NULL |
β |
Communication protocol. One of:
|
speed |
VARCHAR(20) |
NOT NULL |
β |
Speed in km/h. -1 if unknown. |
direction |
INTEGER |
NOT NULL |
β |
Direction in azimuth degrees. -1 if unknown. |
altitude |
INTEGER |
NOT NULL |
β |
Altitude above see level in meeters. 0 if unknown. |
Name |
Type |
Fields |
mobile_devices_pkey |
UNIQUE |
id |
NC_PERSISTENT_STORAGE
Notification channel persistent storage
Name |
Type |
State |
Default |
Description |
πchannel_name |
VARCHAR(63) |
NOT NULL |
β |
Channel name form NOTIFICATION_CHANNELS |
πentry_name |
VARCHAR(127) |
NOT NULL |
β |
Entry name |
entry_value |
VARCHAR(2000) |
NOT NULL |
β |
Entry value |
Name |
Type |
Fields |
nc_persistent_storage_pkey |
UNIQUE |
channel_name,entry_name |
NETWORK_MAP_DELETED_NODES
Stores location on map for deleted objects (to restore it location if object will come back)
Name |
Type |
State |
Default |
Description |
πmap_id |
INTEGER |
NOT NULL |
β |
Network map id NETWORK_MAPS |
πobject_id |
INTEGER |
NOT NULL |
β |
Object if form OBJECT_PROPERTIES |
element_index |
INTEGER |
NOT NULL |
β |
Index of deleted object |
position_x |
INTEGER |
NOT NULL |
β |
Element x coordinate position on map |
position_y |
INTEGER |
NOT NULL |
β |
Element y coordinate position on map |
Name |
Type |
Fields |
network_map_deleted_nodes_pkey |
UNIQUE |
map_id,object_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 |
πlink_id |
INTEGER |
NOT NULL |
β |
Link id |
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. color_source |
INTEGER |
NOT NULL |
β |
Source of color: * MAP_LINK_COLOR_SOURCE_UNDEFINED - -1 * MAP_LINK_COLOR_SOURCE_DEFAULT - 0 * MAP_LINK_COLOR_SOURCE_OBJECT_STATUS - 1 * MAP_LINK_COLOR_SOURCE_CUSTOM_COLOR - 2 * MAP_LINK_COLOR_SOURCE_SCRIPT - 3 |
color |
INTEGER |
NOT NULL |
β |
Int representation of RGB color |
color_provider |
Name |
Type |
Fields |
network_map_links_map_id_pkey |
UNIQUE |
map_id,link_id |
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 |
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_response |
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 |
NOTIFICATION_CHANNELS
Configuration for notification channels
Name |
Type |
State |
Default |
Description |
πname |
VARCHAR(63) |
NOT NULL |
β |
Notification name |
driver_name |
VARCHAR(63) |
NOT NULL |
β |
Driver name |
description |
VARCHAR(255) |
NULL |
β |
Channel description |
configuration |
TEXT |
NULL |
β |
Notification channel configuration |
Name |
Type |
Fields |
notification_channels_pkey |
UNIQUE |
name |
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) |
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 encryption methods |
snmp_oid |
VARCHAR(255) |
NULL |
β |
SNMP object id |
secret |
VARCHAR(88) |
NULL |
β |
Agent shared secret |
agent_port |
INTEGER |
NOT NULL |
β |
Agent port |
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(255) |
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) |
physical_container_id |
INTEGER |
NOT NULL |
β |
Related rack or chassis object ID |
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. |
capabilities |
INTEGER |
NOT NULL |
β |
Node capabilities:
|
icmp_poll_mode |
CHAR(1) |
NOT NULL |
β |
Icmp poll mode 0 - default, 1 - on, 2 - off |
chassis_placement_config |
VARCHAR(2000) |
NULL |
β |
Chassis placement XML configuration |
vendor |
VARCHAR(127) |
NULL |
β |
Vendor |
product_name |
VARCHAR(127) |
NULL |
β |
Product name |
product_version |
VARCHAR(15) |
NULL |
β |
Product version |
product_code |
VARCHAR(31) |
NULL |
β |
Product code |
serial_number |
VARCHAR(31) |
NULL |
β |
Serial number |
cip_device_type |
INTEGER |
NOT NULL |
β |
CIP device type |
cip_status |
INTEGER |
NOT NULL |
β |
CIP status |
cip_state |
INTEGER |
NOT NULL |
β |
CIP state |
cip_vendor_code |
INTEGER |
NOT NULL |
β |
CIP vendor code |
eip_port |
INTEGER |
NOT NULL |
β |
EtherNet/IP port |
eip_proxy |
INTEGER |
NOT NULL |
β |
EtherNet/IP port |
hardware_id |
VARCHAR(40) |
NULL |
β |
Node’s unique hardware id |
agent_cert_mapping_method |
CHAR(1) |
NOT NULL |
β |
Certificate mapping method:
|
agent_cert_mapping_data |
VARCHAR(500) |
NULL |
β |
Agent certificate mapping data |
snmp_engine_id |
VARCHAR(255) |
NULL |
β |
SNMP engine id |
ssh_port |
INTEGER |
NOT NULL |
β |
SSH port for node |
ssh_key_id |
INTEGER |
NOT NULL |
β |
SSH key id form SSH_KEYS |
syslog_codepage |
VARCHAR(15) |
NULL |
β |
Code page used for syslog messages from this node. |
snmp_codepage |
VARCHAR(15) |
NULL |
β |
Code page used for SNMP messages from this node. |
fail_time_ssh |
INTEGER |
NOT NULL |
β |
SSH connection fail UNIX timestamp |
ospf_router_id |
VARCHAR(15) |
NULL |
β |
OSPF router IP address |
mqtt_proxy |
INTEGER |
NOT NULL |
β |
MQTT froxy node id form NODES |
modbus_proxy |
INTEGER |
NOT NULL |
β |
MODBUS froxy node id form NODES |
modbus_tcp_port |
INTEGER |
NOT NULL |
β |
MODBUS TCP port |
modbus_unit_id |
INTEGER |
NOT NULL |
β |
MODBUS unit id |
snmp_context_engine_id |
VARCHAR(255) |
NULL |
β |
SNMP context engine id |
Name |
Type |
Fields |
nodes_pkey |
UNIQUE |
id |
NOTIFICATION_LOG
Table contains log for all sent notifications
Name |
Type |
State |
Default |
Description |
πid |
BIGINT |
NOT NULL |
β |
Unique id. |
notification_timestamp |
INTEGER |
NOT NULL |
β |
UNIX timestamp when notification was sent |
notification_channel |
VARCHAR(63) |
NOT NULL |
β |
Name of notification channel form NOTIFICATION_CHANNELS |
recipient |
VARCHAR(2000) |
NULL |
β |
Recipient list |
subject |
VARCHAR(2000) |
NULL |
β |
Message subject |
message |
VARCHAR(2000) |
NULL |
β |
Message |
success |
CHAR(1) |
NULL |
β |
"1" if message sent successfully and "0" if not |
Name |
Type |
Fields |
notification_log_pkey |
UNIQUE |
id,notification_timestamp |
idx_notification_log_timestamp |
NORMAL |
notification_timestamp |
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_CATEGORIES
Categories of object
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier. |
name |
VARCHAR(63) |
NOT NULL |
β |
Category name. |
icon |
VARCHAR(36) |
NULL |
β |
Icon uid from IMAGES used as icon image. |
map_image |
VARCHAR(36) |
NULL |
β |
Icon uid from IMAGES used as map image. |
Name |
Type |
Fields |
object_categories_pkey |
UNIQUE |
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:
|
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 |
flags |
INTEGER |
NOT 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 |
β |
Defines 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 |
β |
Lactation 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 |
map_image |
VARCHAR(36) |
NOT NULL |
β |
Image GUID form IMAGES, that will be used to display object on network maps. |
drilldown_object_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 |
flags |
INTEGER |
NOT NULL |
β |
Object flags. Node flags:
Interfaces flags:
Templates flags:
Chassis flags:
Object container flags:
Network maps flags:
|
state |
INTEGER |
NOT NULL |
β |
Object state. Data Collection Object (any object that supports data collection) status flags:
Node state flags:
Cluster state flags:
Sensor state flags:
|
creation_time |
INTEGER |
NOT NULL |
β |
Object creation time. |
maint_initiator |
INTEGER |
NOT NULL |
β |
Maintenance initiator user id from USERS. |
alias |
VARCHAR(255) |
NULL |
β |
Object alias |
name_on_map |
VARCHAR(63) |
NULL |
β |
Object name on network map. |
category |
INTEGER |
NOT NULL |
β |
Object category id from OBJECT_CATEGORIES. |
region |
VARCHAR(63) |
NULL |
β |
Address region |
district |
VARCHAR(63) |
NOT NULL |
β |
Address district |
comments_source |
TEXT |
NULL |
β |
Source text of comments with unexpanded macros. |
asset_id |
INTEGER |
NOT NULL |
β |
Linked asset_id |
Name |
Type |
Fields |
object_properties_pkey |
UNIQUE |
object_id |
OBJECT_QUERIES
Saved object queries
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique id of saved object query. |
guid |
VARCHAR(36) |
NOT NULL |
β |
GUID of saved object query. |
name |
VARCHAR(36) |
NOT NULL |
β |
Name |
description |
VARCHAR(255) |
NULL |
β |
Description |
script |
TEXT |
NULL |
β |
Object query filtering script. |
Name |
Type |
Fields |
object_queries_pkey |
UNIQUE |
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_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 |
remote_port |
INTEGER |
NOT NULL |
β |
Remote port for tool execution |
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 |
OSPF_AREAS
OSPF areas
Name |
Type |
State |
Default |
Description |
πnode_id |
INTEGER |
NOT NULL |
β |
Node id form form OBJECT_PROPERTIES |
πarea_id |
VARCHAR(63) |
NOT NULL |
β |
Area id IP address |
Name |
Type |
Fields |
ospf_areas_pkey |
UNIQUE |
node_id,area_id |
OSPF_NEIGHBORS
OSPF neighbors
Name |
Type |
State |
Default |
Description |
πnode_id |
INTEGER |
NOT NULL |
β |
Node id form OBJECT_PROPERTIES |
πrouter_id |
VARCHAR(15) |
NOT NULL |
β |
Router id IP address |
area_id |
VARCHAR(15) |
NULL |
β |
Area id IP address |
πip_address |
VARCHAR(48) |
NOT NULL |
β |
IP address |
remote_node_id |
INTEGER |
NOT NULL |
β |
Remote node id form OBJECT_PROPERTIES |
πif_index |
INTEGER |
NOT NULL |
β |
Interface index |
is_virtual |
CHAR(1) |
NOT NULL |
β |
'1' if virtual and '0' if not |
neighbor_state |
INTEGER |
NOT NULL |
β |
Neighbor state:
|
Name |
Type |
Fields |
ospf_neighbors_pkey |
UNIQUE |
node_id,router_id,if_index,ip_address |
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 |
PHYSICAL_LINKS
Physical links
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique physical link id |
description |
VARCHAR(255) |
NULL |
β |
Physical link description |
left_object_id |
INTEGER |
NOT NULL |
β |
Rack or interface id form OBJECT_PROPERTIES |
left_patch_pannel_id |
INTEGER |
NOT NULL |
β |
Patch panel id form RACKS_PASSIVE_ELEMENTS |
left_port_number |
INTEGER |
NOT NULL |
β |
Port number |
left_front |
CHAR(1) |
NOT NULL |
β |
Flag that states if connection is form the front or from the back. "1" for the front and "0" for the back connection. |
right_object_id |
INTEGER |
NOT NULL |
β |
Rack or interface id form OBJECT_PROPERTIES |
right_patch_pannel_id |
INTEGER |
NOT NULL |
β |
Patch panel id form RACKS_PASSIVE_ELEMENTS |
right_port_number |
INTEGER |
NOT NULL |
β |
Port number |
right_front |
CHAR(1) |
NOT NULL |
β |
Flag that states if connection is form the front or from the back. "1" for the front and "0" for the back connection. |
Name |
Type |
Fields |
physical_links_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_key |
VARCHAR(127) |
NULL |
β |
Timer key |
blocking_timer_key |
VARCHAR(127) |
NULL |
β |
Blocking timer key |
timer_delay |
VARCHAR(127) |
NULL |
β |
Text that will be converted to delay timer |
snooze_time |
VARCHAR(127) |
NULL |
β |
Text that will be converted to snooze timer |
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 |
CAHR(1) |
NOT NULL |
β |
Action that should be done on persistent storage entry 1 for set, 2 for 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 |
πexclusion |
CHAR(1) |
NOT NULL |
β |
1 if current entry is an exclusion entry |
Name |
Type |
Fields |
policy_source_list_pkey |
UNIQUE |
rule_id,object_id,exclusion |
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 |
POLLABLE_OBJECTS
This table contains all objects that have polls.
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Rack id from OBJECT_PROPERTIES |
config_poll_timestamp |
INTEGER |
NOT NULL |
β |
Configuration poll UNIX timestamp |
instance_poll_timestamp |
INTEGER |
NOT NULL |
β |
Configuration poll UNIX timestamp |
Name |
Type |
Fields |
pollable_objects_pkey |
UNIQUE |
id |
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) |
Name |
Type |
Fields |
racks_pkey |
UNIQUE |
id |
RACKS_PASSIVE_ELEMENTS
Rack passive elements
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Passive element unique id |
rack_id |
INTEGER |
NOT NULL |
β |
Rack id form RACKS |
name |
VARCHAR(255) |
NULL |
β |
Passive element name |
type |
INTEGER |
NOT NULL |
β |
Passive element type:
|
position |
INTEGER |
NOT NULL |
β |
Passive element position |
orientation |
INTEGER |
NOT NULL |
β |
Passive element orientation:
|
port_count |
INTEGER |
NOT NULL |
β |
Passive element port count for patch panel |
height |
INTEGER |
NOT NULL |
β |
Element height |
image_front |
VARCHAR(36) |
NULL |
β |
Front image UUID from IMAGES |
image_rear |
VARCHAR(36) |
NULL |
β |
Rear image UUID from IMAGES |
Name |
Type |
Fields |
rack_passive_element_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) |
cache_timestamp |
INTEGER |
NOT NULL |
β |
Timestamp of the oldest value in cash for this DCI (as UNIX timestamp) |
Name |
Type |
Fields |
raw_dci_values_pkey |
UNIQUE |
item_id |
RESPONSIBLE_USERS
Object responsible users.
Name |
Type |
State |
Default |
Description |
πobject_id |
INTEGER |
NOT NULL |
β |
ID of the object. Reference to OBJECT_PROPERTIES. |
πuser_id |
INTEGER |
NOT NULL |
β |
User id. Reference to USERS |
tag |
VARCHAR(31) |
NOT NULL |
β |
User escalation tag |
Name |
Type |
Fields |
responsible_users_pkey |
UNIQUE |
object_id,user_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 |
SENSORS
Sensors specific information
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
ID of the object. Reference to OBJECT_PROPERTIES. |
proxy_node |
INTEGER |
NOT NULL |
β |
Sensor proxy node NODES. |
mac_address |
VARCHAR(16) |
NULL |
β |
MAC address |
device_class |
INTEGER |
NOT NULL |
β |
Sensor device class:
|
vendor |
VARCHAR(128) |
NULL |
β |
Vendor |
communication_protocol |
INTEGER |
NOT NULL |
β |
Communication protocol type:
|
xml_config |
VARCHAR(4000) |
NULL |
β |
Sensor XML configuration. Contain protocol specific configuration |
xml_reg_config |
VARCHAR(4000) |
NULL |
β |
Sensor XML configuration. Contain protocol connection information |
serial_number |
VARCHAR(256) |
NULL |
β |
Device serial number |
device_address |
VARCHAR(256) |
NULL |
β |
Device address |
meta_type |
VARCHAR(256) |
NULL |
β |
Device meta type |
description |
VARCHAR(512) |
NULL |
β |
Device description |
last_connection_time |
INTEGER |
NOT NULL |
β |
Last connection type (as UINIX timestamp) |
frame_count |
INTEGER |
NOT NULL |
β |
Frame count (zero when no info) |
signal_strenght |
INTEGER |
NOT NULL |
β |
Signal streight (1 when no information) |
signal_noise |
INTEGER |
NOT NULL |
β |
Signal noise (*10 from origin number) |
frequency |
INTEGER |
NOT NULL |
β |
Signal frequencty (*10 from origin number) |
Name |
Type |
Fields |
sensors_pkey |
UNIQUE |
id |
SERVER_ACTION_EXECUTION_LOG
Contains log of all executed server actions.
Name |
Type |
State |
Default |
Description |
πid |
BIGINT |
NOT NULL |
β |
Unique identifier. |
action_timestamp |
INTEGER |
NOT NULL |
β |
UNIX timestamp when action was executed. |
action_id |
INTEGER |
NOT NULL |
β |
Action id form ACTIONS. |
action_name |
VARCHAR(63) |
NULL |
β |
Action name form ACTIONS. |
channel_name |
VARCHAR(63) |
NULL |
β |
Channel name form NOTIFICATION_CHANNELS. |
recipient |
VARCHAR(2000) |
NULL |
β |
Recipient list. |
subject |
VARCHAR(2000) |
NULL |
β |
Message subject. |
action_data |
VARCHAR(2000) |
NULL |
β |
Action data. |
event_id |
BIGINT |
NOT NULL |
β |
ID of event that triggered this action execution form EVENT_LOG. |
event_code |
INTEGER |
NULL |
β |
Code of event template that triggered this action execution form EVENT_CFG. |
success |
CHAR(1) |
NULL |
β |
"1" if message sent successfully and "0" if not. |
Name |
Type |
Fields |
server_action_execution_log_pkey |
UNIQUE |
id,action_timestamp |
idx_srv_action_log_timestamp |
NORMAL |
action_timestamp |
SHARED_SECRET
Agent shared secrets stored
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique agent shared secret identifier |
secret |
VARCHAR(88) |
NULL |
β |
Agent secret |
zone |
INTEGER |
NOT NULL |
β |
Zone UIN form ZONES |
Name |
Type |
Fields |
shared_secrets_pkey |
UNIQUE |
id,zone |
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 |
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 |
zone |
INTEGER |
NOT NULL |
β |
Zone id form ZONES |
Name |
Type |
Fields |
snmp_communities_pkey |
UNIQUE |
id,zone |
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 |
transformation_script |
TEXT |
NULL |
β |
NXSL transformation script |
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 |
SOFTWARE_INVENTORY
Node software inventory
Name |
Type |
State |
Default |
Description |
πnode_id |
INTEGER |
NOT NULL |
β |
ID of the object. Reference to NODES. |
name |
VARCHAR(255) |
NOT NULL |
β |
Software name |
version |
VARCHAR(63) |
NOT NULL |
β |
Software version |
vendor |
VARCHAR(63) |
NULL |
β |
Software version |
install_date |
INTEGER |
NOT NULL |
β |
Software installation date (UNIX timestamp) |
url |
VARCHAR(255) |
NULL |
β |
Installation URL |
description |
VARCHAR(255) |
NULL |
β |
Software description |
Name |
Type |
Fields |
software_inventory_pkey |
UNIQUE |
node_id,version,name |
SSH_CREDENTIALS
Table stores SSH credentials used to discover ssh connections.
Name |
Type |
State |
Default |
Description |
πzone_uin |
INTEGER |
NOT NULL |
β |
Zone UIN form ZONES |
πid |
INTEGER |
NOT NULL |
β |
Credential identifier |
login |
VARCHAR(63) |
NULL |
β |
SSH login |
password |
VARCHAR(63) |
NULL |
β |
SSH password |
key_id |
INTEGER |
NULL |
β |
SSH key id from SSH_KEYS |
Name |
Type |
Fields |
ssh_credentials_pkey |
UNIQUE |
zone_uin,id |
SSH_KEYS
Table stores SSH keys configuration
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique key identifier. |
name |
VARCHAR(255) |
NOT NULL |
β |
Key name |
public_key |
VARCHAR(700) |
NULL |
β |
Public key |
private_key |
VARCHAR(1710) |
NULL |
β |
Private key |
Name |
Type |
Fields |
ssh_keys_pkey |
UNIQUE |
id |
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 |
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. Not used when timescale is enabled.
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. Not used when timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
π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 |
item_id,tdata_timestamp |
TDATA_SC_7
Contains historical values for table DCIs with retention time [1 -7] days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from DC_TABLES |
πtdata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
tdata_value |
TEXT |
NULL |
β |
Collected value. |
Name |
Type |
Fields |
tdata_sc_7_key |
NORMAL |
item_id,tdata_timestamp |
TDATA_SC_30
Contains historical values for table DCIs with retention time (7 -30] days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from DC_TABLES |
πtdata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
tdata_value |
TEXT |
NULL |
β |
Collected value. |
Name |
Type |
Fields |
tdata_sc_30_key |
NORMAL |
item_id,tdata_timestamp |
TDATA_SC_90
Contains historical values for table DCIs with retention time (30 -90] days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from DC_TABLES |
πtdata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
tdata_value |
TEXT |
NULL |
β |
Collected value. |
Name |
Type |
Fields |
tdata_sc_90_key |
NORMAL |
item_id,tdata_timestamp |
TDATA_SC_180
Contains historical values for table DCIs with retention time (90 -180] days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from DC_TABLES |
πtdata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
tdata_value |
TEXT |
NULL |
β |
Collected value. |
Name |
Type |
Fields |
tdata_sc_180_key |
NORMAL |
item_id,tdata_timestamp |
TDATA_SC_DEFAULT
Contains historical values for table DCIs with retention time equal to default retention time. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from DC_TABLES |
πtdata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
tdata_value |
TEXT |
NULL |
β |
Collected value. |
Name |
Type |
Fields |
tdata_sc_default_key |
NORMAL |
item_id,tdata_timestamp |
TDATA_SC_OTHER
Contains historical values for table DCIs with retention time more than 180 days. The table is populated only if timescale is enabled.
Name | Type | State | Default | Description |
---|---|---|---|---|
πitem_id |
INTEGER |
NOT NULL |
β |
Item id from DC_TABLES |
πtdata_timestamp |
TIMESTAMPTZ |
NOT NULL |
β |
Unix time stamp for collected value |
tdata_value |
TEXT |
NULL |
β |
Collected value. |
Name |
Type |
Fields |
tdata_sc_other_key |
NORMAL |
item_id,tdata_timestamp |
TEMPLATES
Data collection templates
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique identifier |
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 |
last_event_message |
VARCHAR(2000) |
NULL |
β |
Last generated threshold event message |
Name |
Type |
Fields |
idx_thresholds_sequence |
NORMAL |
sequence_number |
idx_thresholds_item_id |
NORMAL |
item_id |
thresholds_pkey |
UNIQUE |
threshold_id |
TRUCTED_OBJECTS
Trusted objects - used for cross-object access and data collection
Name |
Type |
State |
Default |
Description |
πobject_id |
INTEGER |
NOT NULL |
β |
Object id from OBJECT_PROPERTIES |
πtrusted_object_id |
VARCHAR(63) |
NOT NULL |
β |
Object id from OBJECT_PROPERTIES |
Name |
Type |
Fields |
trusted_objects_pkey |
UNIQUE |
object_id,trusted_object_id |
TWO_FACTOR_AUTHENTICATION_BINDINGS
Two factor authentication method configuration.
Name |
Type |
State |
Default |
Description |
πuser_id |
INTEGER |
NOT NULL |
β |
User id form USERS |
name |
VARCAHR(63) |
NULL |
β |
Driver name form TWO_FACTOR_AUTHENTICATION_METHODS |
configuration |
TEXT |
NULL |
β |
Configuration |
Name |
Type |
Fields |
two_factor_auth_methods_pkey |
UNIQUE |
user_id,name |
TWO_FACTOR_AUTHENTICATION_METHODS
Two factor authentication method configuration.
Name |
Type |
State |
Default |
Description |
πname |
VARCAHR(63) |
NOT NULL |
β |
Two factor method name |
driver |
VARCAHR(63) |
NULL |
β |
Driver name |
description |
VARCAHR(255) |
NULL |
β |
Description |
configuration |
TEXT |
NULL |
β |
Configuration |
Name |
Type |
Fields |
two_factor_auth_methods_pkey |
UNIQUE |
name |
USER_AGENT_NOTIFICATIONS
User agent notifications current and logs
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
User agent notification id |
message |
VARCHAR(1023) |
NULL |
β |
Message |
objects |
VARCHAR(1023) |
NOT NULL |
β |
Coma separaed object id list from OBJECT_PROPERTIES |
start_time |
INTEGER |
NOT NULL |
β |
Message display start time as unix timestamp. 0 - in case if one time notification |
end_time |
INTEGER |
NOT NULL |
β |
Message display end time as unix timestamp. 0 - in case if one time notification |
recall |
CHAR(1) |
NOT NULL |
β |
Flag, that represents if message is recalled |
on_startup |
CHAR(1) |
NOT NULL |
β |
Flag, that represents if message is startup message |
creation_time |
INTEGER |
NOT NULL |
β |
Notification creation time as unix timestamp. |
created_by |
INTEGER |
NOT NULL |
β |
Creator id form USERS |
Name |
Type |
Fields |
user_agent_notifications_pkey |
UNIQUE |
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 |
created |
INTEGER |
NOT NULL |
β |
Group creation time (UNIX timestamp) |
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 |
ldap_dn |
TEXT |
NULL |
β |
LDAP dn |
ldap_unique_id |
VARCHAR(64) |
NULL |
β |
LDAP unique id if field set |
created |
INTEGER |
NOT NULL |
β |
User creation time (UNIX timestamp) |
VARCHAR(127) |
NULL |
β |
||
phone_number |
VARCHAR(63) |
NULL |
β |
Phone number |
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 |
zone |
INTEGER |
NOT NULL |
β |
Zone id form ZONES |
comments |
VARCHAR(255) |
NULL |
β |
Comment to credential entry |
Name |
Type |
Fields |
usm_credentials_pkey |
UNIQUE |
id,zone |
VERSIONABLE_OBJECT
Versionning table for objects
Name |
Type |
State |
Default |
Description |
πobject_id |
INTEGER |
NOT NULL |
β |
ID of the object. Reference to OBJECT_PROPERTIES. |
version |
INTEGER |
NOT NULL |
β |
Object version |
Name |
Type |
Fields |
versionable_object_pkey |
UNIQUE |
object_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 |
WEBSVC_DEFINITIONS
Web service definition table
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Web service id |
guid |
VARCHAR(36) |
NOT NULL |
β |
Web service GUID |
name |
VARCHAR(63) |
NOT NULL |
β |
Web service name |
url |
VARCHAR(4000) |
NULL |
β |
Web service URL |
auth_type |
INTEGER |
NOT NULL |
β |
Authentication type:
|
login |
VARCHAR(255) |
NULL |
β |
Web service login name |
password |
VARCHAR(255) |
NULL |
β |
Web service password |
password |
VARCHAR(255) |
NULL |
β |
Web service password |
cache_retention_time |
INTEGER |
NOT NULL |
β |
Cache retention time |
request_timeout |
INTEGER |
NOT NULL |
β |
Request timeout time |
description |
VARCHAR(2000) |
NULL |
β |
Web service description |
flags |
INTEGER |
NOT NULL |
β |
Web service bit flags:
|
http_request_method |
INTEGER |
NOT NULL |
β |
HTTP request method:
|
request_data |
INTEGER |
NULL |
β |
Request data |
Name |
Type |
Fields |
websvc_definitions_pkey |
UNIQUE |
id |
WEBSVC_HEADERS
Web service header definition table
Name |
Type |
State |
Default |
Description |
πwebsvc_id |
INTEGER |
NOT NULL |
β |
Web service id form WEBSVC_DEFINITIONS. |
πname |
VARCHAR(63) |
NOT NULL |
β |
Header name |
value |
VARCHAR(2000) |
NULL |
β |
Header content |
Name |
Type |
Fields |
websvc_headers_pkey |
UNIQUE |
websvc_id,name |
WELL_KNOWN_PORTS
List of ports, that will be automatically checked for nodes to collect SNMP, SSH or other data
Name |
Type |
State |
Default |
Description |
πid |
INTEGER |
NOT NULL |
β |
Unique agent shared secret identifier |
port |
INTEGER |
NOT NULL |
β |
Agent secret |
zone |
INTEGER |
NOT NULL |
β |
Zone UIN form ZONES |
tag |
VARCAHR(15) |
NOT NULL |
β |
Port tag:
|
Name |
Type |
Fields |
well_known_ports_pkey |
UNIQUE |
id,zone |
WIN_EVENT_LOG
Windows event log
Name |
Type |
State |
Default |
Description |
πid |
BIGINT |
NOT NULL |
β |
Record unique id. |
event_timestamp |
INTEGER |
NOT NULL |
β |
Unix time stamp of event when it came to server. |
node_id |
INTEGER |
NOT NULL |
β |
Source node of the event. Reference to NODES. |
zone_uin |
INTEGER |
NOT NULL |
β |
Zone unique identification number from ZONES. |
origin_timestamp |
INTEGER |
NOT NULL |
β |
Unix time stamp of event when it was created on windows node. |
log_name |
VARCHAR(63) |
NULL |
β |
Alarm key. |
event_source |
VARCHAR(127) |
NULL |
β |
Source of the windows event. |
event_severity |
INTEGER |
NOT NULL |
β |
Windows event severity. |
event_code |
INTEGER |
NOT NULL |
β |
Windows event code. |
message |
VARCHAR(2000) |
NULL |
β |
Windows event message. |
raw_data |
TEXT |
NULL |
β |
Raw Windows event data. |
Name |
Type |
Fields |
win_event_log_pkey |
UNIQUE |
id |
idx_win_event_log_timestamp |
NORMAL |
event_timestamp |
idx_win_event_log_node |
NORMAL |
node_id |
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 |