NetXMS Support Forum

This can be accomplished by copying only one row to a temporary table:

create temp table saved as select * from config where var_name = 'DBConnectionPool.MaxLifetime' limit 1;

delete from config where var_name = 'DBConnectionPool.MaxLifetime';

insert into config select * from saved;

Ok, and if you connect to your DB using postgres tools and run
select * from config where var_name = 'DBConnectionPool.MaxLifetime';

how many lines this query will produce?

So how many entries are there in Configuration->Server Configuration ?

If you open Configuration->Server Configuration in management client and search for 
DBConnectionPool.MaxLifetime

 how many entries with such name are there? If two, delete one of them. 

What DB are you using, what is NetXMS version?

It's stored in the DB, key max len is 255 and value len 2000.
https://www.netxms.org/documentation/datadictionary-latest/#t-persistent-storage

I will check, if data are cached in memory of server proceess.
How much data do you want to store there?

Some info over the Internet suggests that jboss-cli-client.jar is better then then jboss-client.jar, so you may try removing C:\NetXMS\lib\java\jboss-client.jar; part from your classpath

Hi,

this was fixed, fix will be in 4.5 release that is expected in a few days.

View state saving is planned for 5.0 which should be out in January. Rearranging items might require some work, so could be expected somewhere later.

Make sure you've copied all lines of second script - last line should be "return r;"

Try executing this script on any node - right-click a node in object tree, select "Execute script". Paste the script into "Source" and click "Execute" button. In the output it should print, e.g.:


*** FINISHED ***

Result: Infrastructure Services

Hi,

there is %[script_name] macro, that calls a script from script library. This way you can prepare any text that will go into your notifications.
When developing scripts, it's easier to open "Execute script" from context menu of any node. In this case script will be running in context of that node (special variables like $object or $node will be pointing to that specific node). So if you try below script on any node:
sub getParents(o, path) {
  if (o->id == 2) {  // Infrastructure services
    println(path);
  }
  for (p : o->parents) {
    if (path == "") {
      getParents(p, p->name);
    }
    else
    {
      getParents(p, p->name . " > " . path);
    }
  }
}
getParents($object, "");
In will print paths from "Infrastructure services" to that node. The problem is, that a node can be located under several container paths (it's actually a cool feature, as you can arrange your nodes in various ways, e.g. by location, by OS, or you may have a container with nodes that have specific software, require upgrade or attention, etc).
If there are several possible paths, scrip can just print first that it finds, or you can have some ways to instruct the script what path to take, e.g. you can have a custom attribute on some container under "Infrastructure services" and script will be taking only paths that contain that container.

Now we just need to modify above script to return the value instead of printing it:
global r = "";
sub getParents(o, path) {
  if (o->id == 2 and r == "") {  // Infrastructure services
    r = path;
  }
  for (p : o->parents) {
    if (path == "") {
      getParents(p, p->name);
    }
    else
    {
      getParents(p, p->name . " > " . path);
    }
  }
}
getParents($object, "");
return r;
and this is the script that you have to save into script library. It will return first found path.

Hi!

This was just fixed, fix will be available in next release.

The problem is that single quotes are get lost somewhere during all this process. You can specify using "" which will be escaped to " in the end, e.g.:
ExternalMetric=RegQuery.EBTransfer720:""D:\Program
 Files\NetXMS\custom\CheckRegKey\CheckRegKey.exe""
"HKLM\SOFTWARE\WOW6432Node\Aucotec\Engineering Base\7.2.0\Server\Files"
"ImageFilePath"
But better way is to use new (and not yet documented) docker-style syntax:
ExternalMetric=RegQuery.EBTransfer720:['D:\Program
 Files\NetXMS\custom\CheckRegKey\CheckRegKey.exe', 
'HKLM\SOFTWARE\WOW6432Node\Aucotec\Engineering Base\7.2.0\Server\Files', 
'ImageFilePath']

currently that works with single quotes (') only, but in next patch release double quotes (") will also be supported.

FC39 rpms were just released for amd64 and arm64

Ah, right, # is treated as beginning of comment. You can specify password in double quotes (" "), then it can contain # character.
I'm glad that it worked.

Java subagent has a few configuration parameters that can be provided in [JAVA] section of agent configuration file. See the code for list of params:
https://github.com/netxms/netxms/blob/master/src/agent/subagents/java/main.cpp#L131

As I understand, you can use "ClassPath" parameter to add your .jar file.