We have lots of SQL servers and we use the SQL user experience monitors extensively to stay on top of our application health. When my NOC team sees an alert, they pull up their SQL client and run queries they have created to make sure they understand the magnitude of the issue.
To make things faster and easier for them, I'd like to have a page in web console that has links to pull up canned query/stored proc results from some of our production SQL servers.
What would be the best or easiest way to do this? Can report writer query external data sources? Would I have to create an external web page with links to the external data and then link into it from web console?
