Exporting SQL Monitor 2.3 alert data

webrunnerwebrunner Posts: 28 Bronze 1
edited May 24, 2013 5:24AM in SQL Monitor Previous Versions
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.
· Share on Twitter

Comments

  • chriskellychriskelly Posts: 378
    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
    · Share on Twitter
Sign In or Register to comment.