I think I got it I had a bad entry in my sources list with the NetXMS repository.

You can simply use strftime (https://wiki.netxms.org/wiki/NXSL:strftime SetCustomAttribute($node, "timelastcameup", strftime("%d-%m-%Y, %H:%M:%S", $1)); Best regards, Victor

Thank you for giving really good directions: @tursiops said in Determining {instance} for DCI Some.Parameter.ScalarValue(*): You can get a list of available agent lists by right-clicking on a node and selecting (I think) Info->Supported Lists. Bingo. Then followed by nxget utility and I finally see the instances: nxget -l my_host Hardware.Processors @tursiops said in Determining {instance} for DCI Some.Parameter.ScalarValue(*): you will want to use Instance Discovery. Yes, I completly agree. Just tested few simple things - it works!

@tursiops said in Count Wireless Stations: I'm assuming you placed the script into your script library, created a DCI with a "Script" Origin and provided your script name as Parameter and Data Type is Integer? Hi. No I didn't do that. Thanks, you are correct its working now. Much appreciated

Hey. Just FYI, I put the executable in the System32 folder and it executed. This inquiry is resolved. Thanks!

THX Victor, reinstall solve my issue.

Hi Victor, Could you please guide us on setting up Netxms replication using Mariadb Galera. We want to use both Synchronous and Asynchronous replication with one Master Server and multiple Slave Server. Thanks Sushant

I just double-checked on one of our servers and can confirm that at least Windows 2016 isn't using the ifX table (which you are trying to query). Considering SNMP on Windows has been deprecated for a while now, I wouldn't expect that to change. That also means using SNMP is probably not the best way to get this data from a Windows system in general. For the ifTable, you'd want to query .1.3.6.1.2.1.2.2.1.10 for inbound and .1.3.6.1.2.1.2.2.1.16 for outbound. Again, I would not recommend doing this on busy Gigabit or faster connections as counters are going to overflow every few minutes and you won't be able to trust the data you're receiving. There are two ways to setup Agents. The original way is for the NetXMS server to connect to the client. This doesn't require any certificates at all, just a port forward for TCP 4700. If you only have one agent at the other end, this will work just fine for you. The other way are Agent Tunnels, in which case the Agent will connect to the NetXMS server. This one requires certificates on the server (the server will then generate certificates for the clients as needed). There are some guides available on the forum and at least on Linux it looks more complicated than it really is.

You can create script DCI on any node that will calculate required information, and then add DCI container to the map. Best regards, Victor

Your database is locked. Presumably from when you had NetXMS running on WiFi with your system having the IP 192.168.134.1. Hence NetXMS works when you run it on WiFi (same IP that the lock belongs to) and not on your other connection (different IP than the lock). To unlock your database ensure your NetXMS service is stopped and run nxdbmgr unlock

Is this still awaiting implementation?

Hi, it should be fixed in 2.2.17 patch release. Best regards, Victor

Hi, not much changes compared to 2.2. yet. You can find source code here: https://github.com/netxms/netxms/tree/master/src/client/nxapisrv/java Best regards, Victor

Hello together, I have a problem getting connected mac-adresses for the ports of my Cisco switches. This occures on different models and software-releases. CDP isn't activated at ports conected to enduser systems. Same problems occure in my production environment with version 2.0.5 and my testenvironment with version 2.2.16. As my production environment has old software implemented and I have to migrate the next weeks lets concentrate on version 2.2.16. The switches are Cat 3850, 3650, 2960, 4500, 6500 and Nexus n5k. Within NETxms I only see the MAC-Adresses of the peersystems when CDP is enabled on the interface. It seems that the Mac address table can not be read for the other systems. Drivers for the systems are CISCO-GENERIC and CATLYST-Generic. Is there a possibility detecting MAC-adresses for the endsystem ports without activating CDP on these ports at the switch so that they are searchable via tools? Best regards Georg

@idaham said in Timescale DB: @tursiops said in Timescale DB: The NetXMS database schema is different for TimescaleDB (even from Postgres -> TimescaleDB), so you'd have to use nxdbmgr for the migration. It's meant to support migration to TimescaleDB from 2.2.14 onwards (haven't tried it yet, we're still running load tests and comparisons between TimescaleDB and Postgres, feeding 50-60GB of live data into each system per day to compare performance). One thing to note on TimescaleDB use, from what I can tell NetXMS configures the Hypertables with a 1 week chunk interval by default. Depending on your data ingestion rate, you may want to change that before you go live (e.g. for our test, I changed it to 1 day). When feeding 50-60GB of data per day , that represent how many devices/instance ? That was for testing purposes only. I configured a number of firewalls to generate verbose syslog messages on everything and had them send those to the test system, in addition to creating a range of "poll every 5 seconds" DCIs. So it was live data, but not something I'd for a live system. Can't really compare that to a number of nodes. As Victor said, TimescaleDB support is much improved in version 3. I'd suggest waiting for the release or upgrading to version 3 (beta version in 'unstable' repository) if you intend to use it now.

Thanks you. I replace {instance} by $dci->instanceData is ok.

You click one node Open and view in Object Details > Interfaces You can see the column name "ifType"

I USE NODE TOPOLOGY->SWITCH FORWARDING TABLE (MAC ADDRESS TABLE) FOR HP ARUBA SWITCH S2500 & S3500, NetXMS: Version: 2.2.16 Platform: Windows, 64-bit Database: PostgreSQL ALL ARUBA S2500 & S3500 SWITCH  is detected as GENERIC driver by NetXMS. Problem: Switchports that are in access mode in vlan 1, and ports that are in trunk mode and include vlan 1 in trunk vlans list are identified properly. However, ports that do not include vlan 1 are shown as interface name "[ 0 ]" in the "Topology -> Switch forwarding database (MAC address table)" screen. so i can't to know what peer node,problem screen is below [image: problem-mac-forwarding-table.png] .1.3.6.1.2.1.17.1.4.1.2 [image: ..1.3.6.1.2.1.17.1.4.1.2.png] .1.3.6.1.2.1.2.1.0 [image: .1.3.6.1.2.1.2.1.0.png] .1.3.6.1.2.1.2.2.1.1 [image: .1.3.6.1.2.1.2.2.1.1.png] .1.3.6.1.2.1.31.1.1.1.1 [image: .1.3.6.1.2.1.31.1.1.1.1.png] .1.3.6.1.2.1.2.2.1.2 [image: Problem-mac-forwarding-table.png] [image: .1.3.6.1.2.1.17.1.4.1.2.png] [image: .1.3.6.1.2.1.2.1.0.png] [image: .1.3.6.1.2.1.2.2.1.1.png] [image: .1.3.6.1.2.1.31.1.1.1.1.png]

Thanks for the feedback - appreciated. Memory I can add - will go to 24GB and see if noticeable difference. Being windows, shared buffers tops out at 512MB I believe(Windows limit), and to use effective_cache_size instead. Found that exclusions for ativir were not working - getting them fixed to leave postgres folders alone!! As we are SAN based flash, it is fast, but not local, so will leave the commit and WAL settings where they are for the moment. Plugged in 24GB and 2 more cores and got the following. Confirms effective_cache vs shared buffers for windows. Will see how these go. # DB Version: 9.6 # OS Type: windows # DB Type: oltp # Total Memory (RAM): 24 GB # CPUs num: 8 # Data Storage: san max_connections = 300 shared_buffers = 512MB effective_cache_size = 18GB maintenance_work_mem = 1536MB checkpoint_completion_target = 0.9 wal_buffers = 16MB default_statistics_target = 100 random_page_cost = 1.1 work_mem = 6844kB min_wal_size = 2GB max_wal_size = 4GB max_worker_processes = 8 max_parallel_workers_per_gather = 4

continued: is there a generic bandwidth monitoring template for the netxms client? any help appreciated  [image: Step3-A.png] [image: Step3-B.png] [image: Step3-C.png] [image: DataUsage DCI.jpg]