NetXMS Support Forum

The long answer is that I am rebuilding our NetXMS monitoring server.  The previous one was in service for two years.  With all of the new features that have been added, in addition to more experience with NetXMS, I've found better, cleaner ways to do the same monitoring.  That being said, I had created 4 templates, each with 6-12 SNMP-based DCI's and a couple of them had thresholds set.  It appears that none of the DCI's are being saved to the database.

I have a bunch of these errors:

[13-Oct-2014 16:48:07.811] [ERROR] SQL query failed (Query = "INSERT INTO items (node_id,template_id,name,source,datatype,polling_interval,retention_time,status,delta_calculation,transformation,description,instance,template_item_id,flags,resource_id,proxy_node,base_units,unit_multiplier,custom_units_name,perftab_settings,system_tag,snmp_port,snmp_raw_value_type,instd_method,instd_data,instd_filter,samples,comments,item_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"): Operand type clash: int is incompatible with text

I'll have to check with our Sys Admins.  This is running on a MSSQL cluster and occasionally the database gets moved to another server by the cluster service.  I wonder if that factors in.  BTW: I'm running 1.2.16.

Twice now I've had the DCI's in multiple templates disappear.  The most recent occurrence was this past weekend.  I'm the only one with management access so I know it's not something I've done.  It's frustrating to have to re-create these DCI's.  This time I'm going to export them to ease re-creating them, but the bigger issue is why are they disappearing?  What do I need to do to debug this issue?

Cisco Stackwise MIB traps and events.

Juniper IVE MIB traps and events.

Traps and events for Infoblox appliances.  You probably want to modify the event message text since it currently contains the trap description.  It was the only sane way I could think to populate the field with something meaningful.


EDITED: I had to update the xml file since the Infoblox doesn't necessarily send the varbinds in the correct order.

A few more (since I can only add 5 at a time).

I have attached snmp traps and events for Avaya Baystack 5500 (aka Ethernet Routing Switch 5500).

That worked perfectly!  Thanks!  Now, one more question:

Is it possible to access the parameters in the SNMP traps via the $event object?  For example, the AP name is passed as parameter 2, which I've configured as "apLocation" in the Description field in the Trap Parameter Mapping dialog box.  Is it possible to get the value via something like $event->apLocation or GetEventParameter($event,"apLocation")?

BTW: I'm migrating from OpenNMS and I love the power and flexibility of NetXMS while at the same time being easy to configure! 

Thanks for the reply, but I have a couple more questions:

The AP name is sent in parameter 2, which I successfully decode, parse and include in my notification emails.  How do I go about creating the Situation?  I thought about having a situation called "APStatusTraps", but would the AP name be an instance or an attribute of the situation?  Can I use %2 as the macro in the creation of the instance/attribute?

I have an Aruba wireless controller which sends traps when an access point goes down, unfortunately it sends 4 of the same trap (which I've verified by sniffing the traffic).  Since one of the actions in my Event Policy is to send an email, I get 4 of the same email when this occurrs.  The Alarm Browser window shows a count of 4, so I know my Alarm Key is okay.  Is there a way to limit the number of emails to 1?  Would I need to use situations?  Is the Alarm Count available via a NXSL script for use in an Event Filtering script?

Thanks!