NetXMS Support Forum

Thank you Filipp, I changed the DCI to request /cellularBandwidth/unit and it immediately pulled the value down in that field so it is the array that is stopping it. I'll go with plan b and create a powershell script that uses nxpush to import the values into the DCIs.

Hello all,

We are trying to create a DCI that will read an Rest API json response for a value. We set up a web definition called "Test" with the api url, we added the authorization token and application/json headers. I set up the DCI according to the admin guide with "Test:/cellularBandwidth/values/total_usage" but the DCI returns <ERROR>. Here is an example of the json response:

{"cellularRssi":{"unit":"dBm","values":[{"name":"AT\u0026T","data":[{"timestamp":1616719359000,"value":"-27.0"},{"timestamp":1616721157000,"value":"-55.0"},{"timestamp":1616722951000,"value":"-48.0"},{"timestamp":1616724761000,"value":"-36.0"},{"timestamp":1616726556000,"value":"-45.0"},{"timestamp":1616728358000,"value":"-63.0"},{"timestamp":1616730161000,"value":"-52.0"},{"timestamp":1616731961000,"value":"-68.0"},{"timestamp":1616733762000,"value":"-32.0"},{"timestamp":1616735576000,"value":"-39.0"}]}]},"cellularBandwidth":{"unit":"MB","values":[{"name":"AT\u0026T","total_usage":"42.88 MB","data":[{"timestamp":1616722200000,"value":8.62},{"timestamp":1616725800000,"value":9.51},{"timestamp":1616729400000,"value":8.98},{"timestamp":1616733000000,"value":10.82},{"timestamp":1616736600000,"value":4.94}]}]}}

I think it's going to be something simple but I can't seem to find what we are doing wrong. Any help would be appreciated. Thank you!

Howdy,

Has anyone figured out how to report a DCI for multiple nodes with nxreporting? We have cellular routers that are reporting their data usages to netxms and our management would like a report that is emailed to them every monday morning. The issues is I haven't figured out how to create the postgresql query to put into jaspersoft to create the report. Full disclosure I'm a IT Security Admin and not a DB Admin so basic queries I can do but not more technical ones. I was hoping to not having to create a dataset for each of the routers as there is about 110 of them. Thank you in advanced

Quote from: Filipp Sudanov on February 04, 2021, 02:04:57 PM
One possible option is that there is an issue with access right to these nodes. Try enabling "system" user
nxdbmgr reset-system-account
(it's password will be "netxms"). This account has access rights to all objects in the system. Could be that the nodes will be visible (may be in the root of object tree).

Thank you! That allowed me to see the nodes and found someone set access rights for everyone to just allow "Push Data" on all the missing nodes. They were still under the correct subnets just not visible. After asking around to the other admins, I will be giving one of them a little harder time then the others and maybe removing some of their access.

Howdy all,

I've upgrade my server to 3.7.145 and I've noticed in my console that my computer's node is missing. I haven't done a deep dive to see if any other nodes are missing yet. What makes this weird is if I look in the database for my computer, it's there and it's updating it's information like the agent is communicating just not showing up in the consoles. It was there before the server upgrade. Has anybody seen this before?

Thank you

Update: I was able to get my computer to show back in the console but I had to manually remove it from the database and restart the server. i have identified other nodes that are in the database and updating but are not in the console. The are randomly spread out among our subnets. At this point I may have to get a list from the database and go through the console to see what's missing.

I am downloading and importing that one as well. I went back and looked though it and you are right, the AP-TC-MIB says it has them but it really doesn't. I will work this out with Cisco.

Thank you for catching that.

Does anyone know how to fix MIBs that throw an error like "Import Symbol "xyz" unresolved"? I'm trying to import MIBs for our firewalls and 4 of the files throw this error. I've tried fixing them myself but nothing I do seems to work. If I remove them, the rest of the files will import fine. I have attached the MIBs

CISCO-FIREPOWER-AP-EQUIPMENT-MIB: ERROR 001: Import symbol "CfprApEquipmentPsuOperability" unresolved
CISCO-FIREPOWER-AP-PROCESSOR-MIB: ERROR 001: Import symbol "CfprApProcessorUnitId" unresolved

That worked. Thank you!

Howdy,

I have been using Nxshell to create switches that we don't manage and it is creating the switch nodes great. When I try to get it to create the interfaces on the switch, it will create them but it's not setting the flags or the description for each node. It won't set the flags as all and the description is set to the name of the interface even though I use setDescription command. Does anyone know why the following script won't set the flags or description? Other than those, it has been working great.


for i in xrange(0, 48):
    name = "Gi1/0/%d" % (i + 1, )
    cd = NXCObjectCreationData(objects.GenericObject.OBJECT_INTERFACE, name, <parentnodeID>);
    cd.setCreationFlags(flags);
    cd.setDescription("GigabitEthernet1/0/%d");
    cd.setPhysicalPort(True);
    cd.setIfType(6);
    nodeId = session.createObject(cd);
    print '"%s" created, id=%d' % (name, nodeId)


Thank you,
Josh

Howdy,

We have a VMWare server that is not being mapped via CDP on our Cisco C9300 switch. I have confirmed that the the switch can see the server with "sh cdp neighbor" but the Netxms Server is not making the connection. The VMWare server is SNMP active on v2c and the interfaces are populated. My current thought is because the server is connected via a Port-Channel in the switch, the MAC addresses for the physical ports are associated with the port channel and not the interface the cable is plugged into. Is there something I am missing that would help make the connection without the MAC address being in the MAC address table?

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.