Alerts with Stored Procedures? Possible or dreamland

I have created an alert that uses HTML, and SQL, one of the fields we are looking at has the potential to have one, or more elements.

If I have the DBA's write a stored procedure to parse out the elements we need can the alerts utilize the Stored Procedure.. and is there a special place that the alerts will pull from to find it?

thanks

Find more posts tagged with

sql_2008

alerts_configuration

sql

Alerts

Accepted answers

All comments

aLTeReGo

When creating an Custom SQL Alert you select which database table the alert will be querying such as Nodes, groups, volumes, etc. as pictured below. More information can be found in the Administrators guide

http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionCoreAGSettingTriggerConditionAdvancedAlert_3.htm

JWERLEIN

Yes I understand the Alert trigger using SQL ( I am joining the NODES and the Volume Table..

MY question is not the trigger but the alert: CAN I use a stored procedure in the alert section.. I.E. I want to parse out a field that has more than one element , and some junk.. i want to make it readable.. for the Email..

The Trigger condition is attached

The Alert is Here: -EMAIL

The first part: BASIC ORION

${Node.EmailTo}
Maintainer:        ${Node.Maintainers}
Name (Alias):      ${Node.ServerAlias}
Server Name:       ${Node.Caption}
Server Class:      ${Node.Cls}
System(s) :        ${Node.System}
Applications:      ${Node.Applications}

Second Part HTML with some SQL:
Alert: 
 -Current Volume space available: ${VolumeSpaceavailable} / Critical Threshold::
${SQL:Select round((CT/1024/1024/1024),3) from volumes where fullname ='${fullname}'} GB

System Link: \\${Node.caption}:${SQL:Select substring (caption,1,1) from volumes where fullname ='${fullname}'}

Full Name: ${FullName}
Caption (V): ${Caption}

Operations:
• For Critical threshold disk space alerts
 very instructional message for operations...yada yada yada.
• For Warning threshold disk space alerts
 very instructional message for operations...yada yada yada.
• For Normal threshold disk space alerts
 very instructional message for operations...yada yada yada.

Details on this Node and the services can be found here: 
 Volume: ${VolumeDetailsURL} 
 NODE: ${Node.NodesDetailsURL} 

To Acknowlege this alert please click here: ${AcknowledgeURL}

Alert Name: ${AlertName}

aLTeReGo

Without seeing the result of the SQL query itself it's difficult say exactly. Provided your SQL query returns a single column/row value then I don't see any reason why it wouldn't work.