This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Will I need a custom SQL variable?

patriot over 3 years ago

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 mesverrum over 3 years ago

As long as the parent node has that value set it should work.
Cancel
Vote Up 0 Vote Down

Cancel
0 patriot over 3 years ago in reply to mesverrum

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

Cancel
0 mesverrum over 3 years ago in reply to patriot

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>
Cancel
Vote Up 0 Vote Down

Cancel