Print reports of Alerts or provide Excel/DB export
There are no real reporting functions in SQL Monitor. We have a need to print reports based on the Alerts we are receiving and distribute them amongst the appropriate Application Managers/Developers for correction to code. At this time all that can be done is a screen scrape. There has to be reporting functions of the alerts, with details so they can be remedied by other parties than those monitoring the systems.
When receiving email alerts for slow running queries, it would be valuable (more and more so) to have an HTML page with an Export to XLS option, showing the alerts received via email and any/all associated metrics with the slow running queries.
Thanks for the suggestion. I'm interested to know a bit more about what kind of information you'd like to report on and what kind of format. Regarding an alerts report, what would be most useful for the Application Managers/Developers to see?