You can just delete all tables in the database and re-run nxdbmgr init. You can delete all regular tables with attached SQL. Tricky part is to delete all idata_ and tdata_ tables. One option is to use command like this to generate SQL file (Postgres version): psql -c "SELECT id FROM nodes" | grep -ve '[(i-]' | sed -e 's/\s*\([0-9]*\)/DROP TABLE idata_\1; DROP TABLE tdata_\1;/' > drop_data_tables.sql and then run drop_data_tables.sql Best regards, Victor drop_all_tables.sql

What I'm after is to change the output from these two columns to be the result * 8 and Average delta per second. This transform only to effect "bytes-in" and "bytes-out" columns in the table.

I don't have a agent log file. It's only SNMP. How can I fix this? I always get error messages because of this. I don't get this error always. Sometimes I get the error and after 30 minutes it's working fine and I don't get any errors.

Hello NetXMS Community, I just want to ask if it is possible to monitor the Network connection (Wi-Fi and/or Ethernet) of my windows node (server/laptop) just like what task manager is doing? I wanted to create a dashboard to monitor the following: CPU Usage, Memory Usage, Disk Used Space, Disk I/O Queue, and Network in Average. I can find an available DCI parameter template for all of these aside from item #5. Have you tried monitoring yours, or is there other way to monitor it? Thank you in advance! RP

there were no services that were occupying the port (apparently something remained, generating this error). Just simply restart the OS and raise the demon again and without problems. Thanks for the attention, good day!

Maybe its somthing similar to my post, worth reading https://www.netxms.org/forum/general-support/cant-get-powershell-script-to-run/msg27392/#msg27392

Hello, thank you for your fast response. I will try to do it with the version 3.1 and if I have another doubt i will let you know Have a nice day!

please show full output of nxadm -c 'sh st' please show full output of nxadm -c 'sh q' please show graph of NetXMS server: physical memory used by process for the duration for few days - from server start till out of memory event.

ssh functionality is implemented only in ssh.nsm subagent, server does not do ssh communications. So, if you have zoning, you need to load ssh.nsm on zone proxies. If there's no zoning, agent running on netxms server will be used for ssh commands, so you need to enable ssh.nsm there.

HI Victor, Many thanks for your answer. I am so sorry, I found the solution for this and forgot all about this forum. I ended up setting the interface to not be monitored. Kind Regards,

Thank you very much! I was inattentive :-[ Don't know why but now this serene perception of all my attempts reminds me light clouds floating across the sky ??? @filipp-sudanov said in Push DCI values due to register maintenance operations: Try to use -P instead of -p. For me at first it had sounded like a joke (P - parking)

Maybe this will help you: https://www.netxms.org/documentation/adminguide/installation.html#custom-logo-on-login-screen

Thanks for the reply. In later posts i changed the polling method to script file instead of direct command in agent conf. When i changed script content to simple output where i could change execution time, then depending on run time > 4835ms:error | < 4835ms:good. So i think path variable is working. $age = 1500; Start-Sleep -Milliseconds 4840 $Output = 'Parameter.Name=' + $age echo $Output Currently working method: Agent Conf: ExternalParametersProvider=powershell.exe C:\NetXMS\script\ReturnInfo.ps1:1800 ReturnInfo.ps: $DataFile = "C:\NetXMS\script\output.txt" $Array = ""; if (Test-Path -Path $DataFile) { $Content = Get-Content $DataFile $Array = $Content.split('|'); } return $Array Output.txt is generated from different script that is running with task scheduler.

This forum post might help: https://www.netxms.org/forum/general-support/transformations-scripts-for-table-dci/ Note that K/M/G in NetXMS is base 1000, not 1024. Depending on how you intend to use the data, you may want to look at templates and instance discovery instead of table DCIs. There should be plenty of examples in the forum for that (mostly for disk space utilisation and network interfaces).

Thanks for tip. I went with following solution: Agent conf: Query = Alarms-Outstanding:db1:300:SELECT COUNT (alarm_state) as Alarms FROM [netxms_db].[dbo].[alarms] WHERE alarm_state = 0 Dci parameter: DB.QueryResult(Alarms-Outstanding)

Hi, im also ignoring UDF: type = AgentReadParameter($node, "FileSystem.Type(" . $1 . ")"); if ((type == null) || (type == "") || (type == "CDFS") || (type == "UDF")) return false; return true; To identify type, you can add a DCI  with: FileSystem.Type({instance})

Did you try install libc6? Should work with minimal, just need to install the missing library

Set "Repeat event" (in seconds, 86400) in threshold configuration - activation event will be regenerated if threshold is still active.

Thanks for the info. Best regards, Sch.Donat

If your script takes more than 3sec, i would use EXternalParameterProvider. https://wiki.netxms.org/wiki/ExternalParametersProvider