NetXMS Support Forum

The problem is that 2277 is the Netxms server itself, I have converted the sql to utf and got rid of two other problematic nodes but I cannot seem to find this one...

Hi everyone do you know how I can identify the source node from this error? Would like to delete it to get rid of this error...


   "id": 2819476,
   "rootId": 0,
   "code": 52,
   "name": "SYS_DB_QUERY_FAILED",
   "timestamp": 1654279789,
   "originTimestamp": 1654279789,
   "origin": 0,
   "source": 2277,
   "zone": 0,
   "dci": 0,
   "severity": 4,
   "message": "Database query failed (Query: INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?); Error: Duplicate entry '6733-Cisco AnyConnect Secure Mobility Client -4.7.04056' for key 'PRIMARY')",
   "lastAlarmKey": "SERVICE_NOT_RUNNING_8ED0B4979152E0DCB6AABCDFC6194391_0x000008E5",
   "lastAlarmMessage": "",
   "tags": null,
   "parameters": [
      {
         "name": "query",
         "value": "INSERT INTO software_inventory (node_id,name,version,vendor,install_date,url,description) VALUES (?,?,?,?,?,?,?)"
      },
      {
         "name": "message",
         "value": "Duplicate entry '6733-Cisco AnyConnect Secure Mobility Client -4.7.04056' for key 'PRIMARY'"
      },
      {
         "name": "connectionLost",
         "value": "0"
      },
      {
         "name": "hash",
         "value": "8ED0B4979152E0DCB6AABCDFC6194391"
      }
   ]

Ill add some more info to this. If someone wants a more readable status of the service poll you should under General change Data type to "String"

Then you go to Transformation and paste this code:

switch ( $1 )
{
case "0": return "Running";
case "1": return "Paused";
case "2": return "Start pending";
case "3": return "Pause pending";
case "4": return "Continue pending";
case "5": return "Stop pending";
case "6": return "Stopped";
case "255": return "Unable to get service state";
default: return "INVALID VALUE (".$1.")";
}

If you want to get notified via lets say e-mail when a service stops you will need to look at Thresholds, Event processing policy and also Actions configuration.

Thank you so much 

You know what i did i pasted the code in "Instance Discovery -> Instance discover filter script". No wonder it didnt work 

Thanks again and have a great day.

Can you guys in this thread please show me with a couple of screenshots how you configured this. It seems im missing something out in my data collection configuration / template.

Thank you so much for the answer this is not an issue for me just wanted to get more info in the mail but i can always go and check for the information i netxms afterwards.

Quick little question is it doable to include the message that is stored under the Windows eventlog on triggered events in a mail message? If so what variable would that be?

• Grafana integration?
  

Do we still need to checkout source from git and compile webapi?
https://wiki.netxms.org/wiki/NetXMS_WebAPI

Thank you very much for the instructions.

Thank you so much for the information i will try this out tomorrow.

What are the requirements on the netxms side to get the grafana netxms module to work?
https://github.com/netxms/grafana

I have installed the netxms webui just in case

I dont know what to enter in the API base url section?

Next template is for synology nases out there 

TODO: Find a way to show disk usage on ex. Volume 1

Sorry i cannot test to see if this works as i uninstalled this test server and moved it to a production one. Will test next time though if i get this error again.

Victor you have thought of everything it seems Thanks for the clarification i need to rtfm.

I got another question can we choose how often ExternalParameter script runs? Like the ExternalParametersProvider?

Thoose checks will end up showing on the monitor server itself not on the esxi servers details page. Is there anyway we can redirect thoose outputs to show up on the esxi object instead? I looked up nxapush but couldnt redirect that to another host. One idea would be to create a DCI on a object (ESXI) and then use nxapush to pass the id of that DCI that i would like to send the data to.