cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

Will I need a custom SQL variable?

I want to be able to send a node custom property as a variable in an interface alert, but I find that if I change the "Insert Variable" menu to Nodes, and then select the Node Custom Property, that it will not display the value in the email that is sent. Will I have to configure a Custom SQL variable to do this, or should I just create an analogous interface custom property and populate it?

If custom SQL is the best option, what would the query be to show, for example, the node cp of "City" in the Interface alert message?

Thanks for nay help

0 Kudos
3 Replies

As long as the parent node has that value set it should work.
- Marc Netterfield, Github
0 Kudos

That's what I thought, but I find that the Node custom property field is empty in the report. Ideas?

0 Kudos

This is a trimmed down version of an interface alert message template i have used where i was able to bring in node custom properties no problem.

<font color="red"><b>
${N=Alerting;M=AlertMessage}
</b></font>
Interface Details for <a href="${N=SwisEntity;M=DetailsUrl}">${N=SwisEntity;M=Caption}</a>
Internal Name: ${N=SwisEntity;M=IfName}
Interface Type: ${N=SwisEntity;M=TypeDescription}
Bandwidth: ${N=SwisEntity;M=InBandwidth;F=Bandwidth} RX - ${N=SwisEntity;M=OutBandwidth;F=Bandwidth} TX
Support_Phone: ${N=SwisEntity;M=CustomProperties.Support_Phone}
Circuit_Provider: ${N=SwisEntity;M=CustomProperties.Circuit_Provider}
Account Number: ${N=SwisEntity;M=CustomProperties.Account_Number}
Circuit ID: ${N=SwisEntity;M=CustomProperties.CKTID}
Address: ${N=SwisEntity;M=CustomProperties.Address}
Notes: ${N=SwisEntity;M=CustomProperties.Notes}

Node Details for <a href="${N=SwisEntity;M=Node.DetailsUrl}">${N=SwisEntity;M=Node.Caption}</a>
IP: ${N=SwisEntity;M=Node.IP_Address}
DNS: ${N=SwisEntity;M=Node.DNS}
Hostname: ${N=SwisEntity;M=Node.SysName}
Priority: ${N=SwisEntity;M=Node.CustomProperties.Priority}
Department: ${N=SwisEntity;M=Node.CustomProperties.Department}
Device Type: ${N=SwisEntity;M=Node.CustomProperties.Device_Type}
Vendor and Model: ${N=SwisEntity;M=Node.Vendor} ${N=SwisEntity;M=Node.MachineType}
Environment: ${N=SwisEntity;M=Node.CustomProperties.Environment}
Site Name: ${N=SwisEntity;M=Node.CustomProperties.Site_Name}
Address: ${N=SwisEntity;M=Node.CustomProperties.Address}
Vendor Support: ${N=SwisEntity;M=Node.CustomProperties.Support_Contact}
Serial: ${N=SwisEntity;M=Node.CustomProperties.SerialNumber}
Notes: ${N=SwisEntity;M=Node.CustomProperties.Notes}

<a href="${N=Alerting;M=AlertDetailsUrl}">Click here for Alert Info</a>

- Marc Netterfield, Github
0 Kudos