So I am fairly new to Solar Winds and I've been asked to update a "Node Status down" alert to include information for a remote database with contact info, etc for the site.
Currently the email is this:
ALERT: ${NetObjectName} is ${Status} at ${AlertTriggerTime}
${NetObjectName} has been down for more than 15 minutes.
http://solarwinds.*****.com etc
IP: ${IP_Address}
and I would like it to pull from remote databases we'll call 'leasing' and 'accounts' to add the extra info to the alert email following the IP
The problem being is I need it to trigger off of the IP in the alert to pull the info for the specific site and I can't get the query to work. The overall SQL query works, but it breaks when trying to interface it with SW
I'm currently trying to get it to work in various ways the most recent of which was this (heavily truncated):
Select foo
From leases, accounts
where PSQL01.leases.dbo.leasestatus= 'open' and PSQL01.leases.dbo.market = (Select mkt from NETADM01.solarwindsorion.dbo.nodes where IP_Address = ${IP_Address})
Is it even possible to get the extra info to pull into the email the way I need it to and if so does anyone have any idea how?
Thanks!
Chad
