NetXMS Support Forum

Hello

When polling MS Sql database with agent, what shoud be written in database name as the query is generic and not specific to single database ?

Database = id=db3;driver=mssql.ddr;server=x.x.x.x;dbname=????;login=xxxx;password=xxxxx
Query = query:db3:300:SELECT Count(name) From sys.databases WHERE database_id > 4 AND group_database_id IS not NULL

Hello

What would be the best way to create dci, that check two other dcie values?

For example Router version and firmware and alert when they dont equal each other.

Egert

Hello

When creating DCi with instance discovery how can i parse the name to remove text between "[" and "]" inlcuding brackets also?

Example name: Camera - Name a - b - c [4a613e60-77f3-4e32-8d8e-d4723d945b98]


Egert

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

Hello

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

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

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

Hello

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

Egert

Hello

What is the correct way to filter by multiple attributes ?

For example, show tool only when both attributeA and attributeB is present under custom attributes.

Egert

Hello

What could cause constant peer hopping between interfaces. I have Mikrotik router with Cisco switch. They are connected via trunk port. In event logs the switch (peer) is constantly changing between Bridge interface and eth 5 (interface with public ip).

Logs:
15602046 21.10.2020 13:09:22 21.10.2020 13:09:22 System [Router] Site Default 0 SYS_IF_PEER_CHANGED Normal New peer for interface Bridge is [Sw] Site - Core interface Gi1/0/24 (A4:B2:39:C3:4D:98) 0
15601843 21.10.2020 13:04:48 21.10.2020 13:04:48 System [Router] Site Default 0 SYS_IF_PEER_CHANGED Normal New peer for interface ether5 is [Sw] Site - Core interface Gi1/0/24 (A4:B2:39:C3:4D:98) 0
15600621 21.10.2020 12:39:16 21.10.2020 12:39:16 System [Router] Site Default 0 SYS_IF_PEER_CHANGED Normal New peer for interface Bridge is [Sw] Site - Core interface Gi1/0/24 (A4:B2:39:C3:4D:98) 0
15600356 21.10.2020 12:34:46 21.10.2020 12:34:46 System [Router] Site Default 0 SYS_IF_PEER_CHANGED Normal New peer for interface ether5 is [Sw] Site - Core interface Gi1/0/24 (A4:B2:39:C3:4D:98) 0
15599406 21.10.2020 12:09:04 21.10.2020 12:09:04 System [Router] Site Default 0 SYS_IF_PEER_CHANGED Normal New peer for interface Bridge is [Sw] Site - Core interface Gi1/0/24 (A4:B2:39:C3:4D:98) 0
15599315 21.10.2020 12:04:41 21.10.2020 12:04:41 System [Router] Site Default 0 SYS_IF_PEER_CHANGED Normal New peer for interface ether5 is [Sw] Site - Core interface Gi1/0/24 (A4:B2:39:C3:4D:98) 0
15598004 21.10.2020 11:39:01 21.10.2020 11:39:01 System [Router] Site Default 0 SYS_IF_PEER_CHANGED Normal New peer for interface Bridge is [Sw] Site - Core interface Gi1/0/24 (A4:B2:39:C3:4D:98) 0
15597867 21.10.2020 11:34:38 21.10.2020 11:34:38 System [Router] Site Default 0 SYS_IF_PEER_CHANGED Normal New peer for interface ether5 is [Sw] Site - Core interface Gi1/0/24 (A4:B2:39:C3:4D:98) 0

Hello

Has anyone experienced following issue: I have set NetXms to poll Mikrotik router via ssh and each time when attempt is made, router generates error "can't agree on KEX algorithms". When i log in manualy via ssh, then no error. Seems like it started with NetXms version 3.5.90. It used to work on older version and polling script hasent changed.

Egert

Is it possible to send config change to cisco switch (2960x) with scheduled action ? For example move interface to different vlan ?

Hello

How hard would it be to make alert based on historical trends? For example if interface speed is unusualy low for given period.

Egert

Hello

Would it be possible to add shortcut to node right click menu, where link to maps would be shown (list of maps where speific node exists)?

Egert

Hello

Any tips how to solve following error message, i get it when trying to migrate from MSSQL to Postgresql?

Migrating table snmp_ports
SQL query failed (23505 ERROR:  duplicate key value violates unique constraint "
snmp_ports_pkey"
DETAIL:  Key (id)=(1) already exists.):
INSERT INTO snmp_ports (id,port,zone) VALUES (?,?,?)
Failed input record:
   id = "1"
   port = "161"
   zone = "0"
Database migration failed.

Today i noticed a different behavior from NetXms, not sure from what version it started.

Basicly i have template for each logical drive letter: C,D,E etc. In that template, 2 dci is created per drive and one dci is with threshold value "%{dci-DiskFreeGB-C:50}". "dci-DiskFreeGB-C" is inherited from template and by default is empty. So expected behavior was when drive free space is under 50, trigger alert. But today i noticed that when empty "dci-DiskFreeGB-C" is inherited no alerts are triggered. When i set "dci-DiskFreeGB-C" manualy to 50 then it will work. So easy fix right, lets set template inherited value to 50, but for some reason it wount be inherited. Even if i remove node from template and do another config discovery, still no luck. Next i tryed to removed template custom atribute and re add note, from some mysterios place it still auto inherits it.

Any ideas ?

Hello

After adding dci container to network map, map is broken. No scroll bars and no tool icons (top right corner). Where are map elements stored in db so i could remove it manualy and restore map?

Also would it be possible to add some check when inserting dci containers so it would not be so easy to break map?

format string that broke map: "Packet Loss: %s %"

Egert

Hello

Would it be possible to add "Package Manager" option to deploy package once agent is online ?

Egert

Hello

Is it possible to create "advanced" dci poll like:

Example 1: Check if windows service is running and network speed is above some value. If some criteria is not matched, return specific alert message, not just general error.

Example 2: Check for multiple wifi ap frequencis on same tower and if they overlap then alert, but with specific message again, like what ap's are overlaping.

Example 3: Count specific node events per given time. Like Event X happened over last 7 days.

Egert

Hello

What could cause the following behavior: Lets say i have Ubiquity ap added to NetXms and with template it gets dci-s to monitor. Under that template there is instance discovery for every connected station. Now when station gets disconnected for x amount of time, the instance dci values turn into unsupported. When station returns the dci monitoring continues but alerts for unsupported never dissapear. I checked manualy and oid is same in old and new discovery. Any way how to auto terminate them ?

Egert