Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

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

Find more posts tagged with

Accepted answers

All comments

mesverrum

As long as the parent node has that value set it should work.

patriot

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

mesverrum

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>