Alerting issue on Custom Node Poller

sachsj

 

I have created a custom poller for dsx1TotalESs so I can watch errored seconds on my ds1 interfaces.

 

I have successfully added the poller to my node page and written a report to show top 10 list.

 

The alert works, but the problem is I cannot get the T1 0/1/0 or T1 0/1/1 interface name to show up for the alert when it emails me.

 

I have tried the following variables and nothing seems to return anything useful.

 

${InterfaceName}

${Caption}

${node.interfaceName}

${CustomPollers.LabelType}

${CustomPollers.LabelDetail}

${AssignmentName}

${CustomPollers.LabelType as InterfaceType}

${CustomPollers.LabelDetail as InterfaceType}

${node.Interfaces.Caption AS Interface_Caption}

 

 

Here is the Trigger Condition

 

Poller Name is equal to dsx1TotalESs

Status is greater than 100

Thanks in advance for any help.

nelsonc0

Try this in your message

${SQL:select interfaces.interfacename from interfaces join nodes on nodes.nodeid = interfaces.nodeid join custompollerassignment as cpa on nodes.nodeid = cpa.nodeid where cpa.custompollerassignmentid = '${CustomPollerStatus.CustomPollerAssignmentID}'}