NetXMS Support Forum

Name: &Connect->Chrome HTTP
Command: chrome.exe --app=https://%u

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?