Version 3:
- changed custom property "hname" in nodes table to "caption" for general consumption.
- updated hyperlink bit at bottom for cosmetics.
Version 2:
This is for my ops center who wanted customized alerts page.
report calls stored procedure b/c of case statements.
just use view w/ report resource pointing to this report.
had to use case statements to get node name/caption to show up for different alerts and join matches on different tables based on type of alert.
Same for NodeID so I could hyperlink caption/name.
Changes:
got rid of case statements and used an insert for alerts, then update statements for many of the different "object types".
-- Update Notes:8/28/2013 - Added top part of object types below
/* all distinct object types by
query: select distinct(ObjectType) from AlertDefinitions
Node
Interface
Group
APM: Hardware Sensor
IP SLA QoS
APM: Component
APM: Application
Custom Node Poller
Step
Step Request
Transaction
Volume
Not done yet:::
Auditing Events
IPAM Networks
Location
Moved MAC
Multicast routing
NTA: CBQoS Class Map
Polling Engines
Rogue DNSName
Rogue IPAddress
Rogue MACAddress
Routing Neighbors
UDT: MACAddress
VoIP CallManager
VoIP Infrastructure
VoIP Phone
VoIP Region
Watch List
Wireless Access Point
Wireless Controller
*/
below is pic of view created for these reports. here is the bit for the hyperlink part:
<b style='color:red'>NON Ackd</b><a href="">thwack.solarwinds.com/.../alerts.aspx"> - Click to Ack Alerts </a>
