Exporting SQL Monitor 2.3 alert data

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Exporting SQL Monitor 2.3 alert data

Postby webrunner » Wed May 22, 2013 5:16 pm

Hello,

Is there any way to export data (Excel or CSV) from the list of uncleared alerts that show when one clicks Overview?

I have a list of Deadlock alerts and would like not to have to go through them one by one. I know this data is in the RedGateMonitor database somewhere but -- if there is no easy way to export from the Admin site -- I don't know the exact tables and queries to use to extract the data.

Thanks for any help. Let me know if you need any more information.
webrunner
 
Posts: 13
Joined: Tue Apr 19, 2011 3:45 pm

Postby chriskelly » Fri May 24, 2013 10:24 am

Unfortunately, this is difficult. The data for any alert is not stored in one particular table within the data repository. Also the development team have not been able to provide documentation to help.

I would recommend that you post a suggestion on the SQL Monitor UserVoice Forum. This is used by the development team to gather suggestions and gauge interest in those ideas. At the very least you should get a better response direct from the development team.

https://sqlmonitor.uservoice.com/forums ... uggestions
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest