I've had a pretty good look around and couldn't find anything that did what I'm looking for. There is one post in your referenced list that deals with Active Alerts but it is pretty old and has a post stating that it throws errors in later versions. From the age of the post and the error I think it is a reasonable assumption that the DB has changed. I suppose I'm trying to get a very similar result to the standard "Alerts" Menu Option (with some additional Custom Property fields to make it more meaningful locally) but the code for that query is not available to me.
I've written a simple SQL query (below) that gives me the easy part of the result, but without the additional data that enables hyperlinking and access to the custom properties (as I said my SQL skills are poor to non-existent), and it includes some extra rows that don't appear in the Alerts Menu Option result.
AlertStatus.TriggerTimeStamp AS EventStart,
AlertStatus.ActiveObject AS ActiveObject,
AlertStatus.ObjectName AS ObjectName
ORDER BY EventStart DESC
Any assistance would be appreciated.
I'd like to be able to display the following :
- Time of Alert
- Alert name
- Network Object (Alerts) or Caption (Message center) - (I'd like a hyperlink on this as per Alerts Menu output that goes to relevant node/volume/APMcomponent etc). A mouse over display would also be good but not essential (it would be nice to have some control over what appears in this mouse over display - future enhancement?)
- Node (with hyperlink)
- Node/Volume related Custom Property values if possible
One report can be created to display the first three items. However, with your additional request to provide hyperlinks as well items 4 and 5, I believe five separate reports would be needed to fulfill this request. Each report would cover the following: nodes, volumes, interfaces, APM applications, APM components. Additional reports would be required for other types of alerts such as groups and virtual machines.
If you're willing, I can walk you through updating the following reports you referenced so that it executes properly.
Are there any known reports that can show triggered alerts for say the last month and how long they were "active" for?
I believe this is possible but again, will require a different report. Let me know if you're willing to work on the aforementioned reports first.