NetXMS Support Forum

Also does anyone know of a way to manually add component to devices that won't allow for any type of monitoring other than pings (no SNMP or agent). We would like to add the serial number of said devices via a component of the node for inventory purposes.

Thanks again,
Josh

Good morning!

We are loving Netxms and what all it can do. We are slow integrating it with a lot of our systems. One question that has come up is, how do we manual specify a peer for an interface? We are an University Department, we do not control the switches that most our user devices are plugged into. What switches we do control we have managed to get the peer interfaces populated. We can physically get to the switch that the devices are plugged into, so we know what ports they are in but we would like to reflect that in Netxms if possible. Does anyone know how I can do this?

Thank you in advance,
Josh

Howdy,

We were trying to get an agent to monitor SSL certificate expiration dates. We were able to achieve this with the ExternalParameterShellExec command, regex and some other commands to calculate the remaining seconds before expiration. My manager wanted me to create a table with all our SSL websites and the remaining time for each. I tried several ways to use regex to validate the string before the calculations but it seems that the transformation script on the Data Collection table doesn't support regex at all. Below are the two ways I tried to get regex to work, I use the "match" version in the ExternalParameterShellExec command and it's working flawless. If there is any regex in the transformation script, the collection errors out.


idate = $1->getColumnIndex("Date");
ireman = $1->getColumnIndex("Remaining");
for (i=0; i<$1->rowCount; i++)
{
   value = $1->get(i,idate);
   if (value match "^([A-Za-z]+)\s+([0-9]+)\s+([0-9]+):([0-9]+):([0-9]+)\s+([0-9]+)")
  {
     //alot of conversion and math is omitted
     $1->set(i,ireman,value);
  }
}



idate = $1->getColumnIndex("Date");
ireman = $1->getColumnIndex("Remaining");
for (i=0; i<$1->rowCount; i++)
{
   value = $1->get(i,idate);
   if (value ~= "^([A-Za-z]+)\s+([0-9]+)\s+([0-9]+):([0-9]+):([0-9]+)\s+([0-9]+)")
  {
     //alot of conversion and math is omitted
     $1->set(i,ireman,value);
  }
}


I've also tried to just inject a value myself instead of pulling from the table and it still gives an Error on updating the table


idate = $1->getColumnIndex("Date");
ireman = $1->getColumnIndex("Remaining");
for (i=0; i<$1->rowCount; i++)
{
        value = 1;
if (value ~= "([0-9])") //tried both match and ~= for the regex
{
$1->set(i,ireman,1);
}
}


I can't seem to find the answer on the forum of in any documentation that I can find. Any help would be appreciated.

Thank you,
Josh

Howdy,

We are trying to install version 3.4.310 on Windows Server 2019 with postgres (we have also tried MS SQL). We get the install to work correctly and the database up and running quickly. When we add any users (local or LDAP) to the built-in Admin group, we get the following errors in the log files:

2020.08.14 17:34:43.135 *E* [db.drv             ] SQL query failed (Query = "SELECT id FROM user_groups WHERE id=?"): 22003 ERROR:  value "2147483649" is out of range for type integer
2020.08.14 17:34:43.150 *E* [db.drv             ] SQL query failed (Query = "INSERT INTO user_groups (name,system_access,flags,description,guid,ldap_dn,ldap_unique_id,created,id) VALUES (?,?,?,?,?,?,?,?,?)"): 23505 ERROR:  duplicate key value violates unique constraint "user_groups_pkey"
DETAIL:  Key (id)=(-2147483647) already exists.

No matter how we add the users (either through the user panel or the group panel itself). We have also created a group and added users, which gave the same error. Any help would be appreciated.

Thank you in advance.