NetXMS Support Forum

Hello

Is it possible to extract data with web service from this sample data (its returned in webpage):

{"py/object": "detector.api.Snapshot", "time": 1607485618.4846845, "version": "v1.2.3", "detections": [], "antenna_gps": {"py/tuple": [01.12343455, 02.45542]}, "antenna_gps_locked": true, "antenna_temp": -6.816406250000001, "antenna_yaw": 354.90458852191114, "jamming": false, "is_battery_powered": false, "battery_percent": 0, "suspended": false}

if yes, is it enought to fill in only name and url? Also in dci settings what is the correct parameter for example to get version info ?

Egert

Many thanks for greate examples, got it working and went with mapping table version.

Egert

Thanks for the example. Why would mapping tables be better choice ?

Also seems like no easy way to get node mac address like %{node_primary_ip} ?

Egert

Hello

What is the best way to get "https://api.macvendors.com/%{node_mac}" result as DCI value and apply that via template ?

Egert

Can confirm, after update no more failed db queries.

Egert

Hello

Is Nexus driver bug fix also included ?
https://www.netxms.org/forum/general-support/failed-db-query-count/

Egert

Nexus devices are monitored yes.

Version is 3.7.95 and database is PostgreSQL.

Egert

Hello

I was testing different DCi options for internal server monitoring, and i found parameter "Server.DB.Queries.Failed" that returns 2164256 failed querys, that surely cant be good number?
After that i checked event monitor and there are multiple entries about: 08.01.2021 10:25:33 NetXms Critical SYS_DB_QUERY_FAILED Database query failed (Query: INSERT INTO interface_vlan_list (iface_id,vlan_id) VALUES (?,?); Error: 23505 ERROR:  duplicate key value violates unique constraint "interface_vlan_list_pkey"
DETAIL:  Key (iface_id, vlan_id)=(104256, 1) already exists.)

How to fix that ?

Egert

Hello

Is it my eye sight or did server console option dissapear with new version ? User has access server console enabled but no option to actualy select it.

Egert

Hello

What would be the easiest solution to implement simple parent configuration? For example show node status as unknown when parent is down. It works with some devices but not all of them. For example Ubiquiti links and mikrotik devices wount show that, or if there is some managed switch thats not fully supported.

Egert

Debugging is bit hard, the time it takes to run poll (about 5-10 sec) there will be 45000 lines generated.

Egert

There are some snmp dcis aswell, they indeed show error when node down.

I ran poll->status: when node is not pinging, for some reason node is still "Up"

[19.11.2020 08:41:09] **** Poll request sent to server ****
[19.11.2020 08:41:09] Poll request accepted
[19.11.2020 08:41:09] Starting status poll for node TestNode
[19.11.2020 08:41:09] Checking SNMP agent connectivity
[19.11.2020 08:41:09] SNMP agent unreachable
[19.11.2020 08:41:09]    Starting status poll on access point TestNode
[19.11.2020 08:41:09]       Current access point status is NORMAL
[19.11.2020 08:41:09]       Access point status after poll is NORMAL
[19.11.2020 08:41:09]    Finished status poll on access point TestNode
[19.11.2020 08:41:09]    Starting status poll on interface lte1
[19.11.2020 08:41:09]       Current interface status is NORMAL
[19.11.2020 08:41:09]       Starting ICMP ping
[19.11.2020 08:41:09]       Interface is NORMAL for 3763 polls (1 poll required for status change)
[19.11.2020 08:41:09]       Interface status after poll is NORMAL
[19.11.2020 08:41:09]    Finished status poll on interface lte1
[19.11.2020 08:41:09]    Starting status poll on interface wlan1
[19.11.2020 08:41:09]       Current interface status is UNKNOWN
[19.11.2020 08:41:09]       Interface status cannot be determined
[19.11.2020 08:41:09]       Interface is UNKNOWN for 365 polls (1 poll required for status change)
[19.11.2020 08:41:09]       Interface status after poll is UNKNOWN
[19.11.2020 08:41:09]    Finished status poll on interface wlan1
[19.11.2020 08:41:09]    Starting status poll on interface ether1
[19.11.2020 08:41:09]       Current interface status is UNKNOWN
[19.11.2020 08:41:09]       Interface status cannot be determined
[19.11.2020 08:41:09]       Interface is UNKNOWN for 365 polls (1 poll required for status change)
[19.11.2020 08:41:09]       Interface status after poll is UNKNOWN
[19.11.2020 08:41:09]    Finished status poll on interface ether1
[19.11.2020 08:41:09]    Starting status poll on interface Bridge
[19.11.2020 08:41:09]       Current interface status is NORMAL
[19.11.2020 08:41:09]       Starting ICMP ping
[19.11.2020 08:41:09]       Interface is NORMAL for 3763 polls (1 poll required for status change)
[19.11.2020 08:41:09]       Interface status after poll is NORMAL
[19.11.2020 08:41:09]    Finished status poll on interface Bridge
[19.11.2020 08:41:10] Node is connected
[19.11.2020 08:41:10] Finished status poll for node TestNode
[19.11.2020 08:41:10] Node status after poll is NORMAL
[19.11.2020 08:41:10] **** Poll completed successfully ****

Device is Mikrotik router, monitored by icmp and snmp. When device is down, some snmp dci-s remain "up" for example ICMP.PacketLoss and ICMP.ResponseTime.Last. They keep reporting last values. And that causes device never to be shown as down.

Hello

How can i setup node monitoring so if ping fails node is shown as down, no matter what other dcis report ?

Egert