locked
How to Export Management Pack Alets to Excel? RRS feed

  • Question

  • Hello,

    We have 150 or some odd Management Packs in SCOM.  For each Management Pack, we would like to export the alerts to Excel for a few reasons.  Can this be done and if so, can you plz provide the steps/details.  Thanks in advance.


    Thanks for your help! SdeDot

    Friday, May 11, 2012 2:26 PM

Answers

  • There is a tool called MP Viewer that will allow you to load up a MP and export the data to Excel.  It does a nice job, but with 150 that's going to take a lot of time.  Furthermore, the values for monitors will not be visible.

    I believe you can also export rules / monitors from a given mp via powershell and probably port it to a csv file.  Not sure how pretty that would be and or look.

    http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/85505/Default.aspx

    There you go, that post will do the trick for you I believe.


    Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/

    • Marked as answer by SdeDot Thursday, May 17, 2012 10:11 PM
    Friday, May 11, 2012 3:55 PM

All replies

  • There is a tool called MP Viewer that will allow you to load up a MP and export the data to Excel.  It does a nice job, but with 150 that's going to take a lot of time.  Furthermore, the values for monitors will not be visible.

    I believe you can also export rules / monitors from a given mp via powershell and probably port it to a csv file.  Not sure how pretty that would be and or look.

    http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/85505/Default.aspx

    There you go, that post will do the trick for you I believe.


    Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/

    • Marked as answer by SdeDot Thursday, May 17, 2012 10:11 PM
    Friday, May 11, 2012 3:55 PM
  • Thanks for the replay Blake.  So far the post seems to be what Im looking for, so let me look at it over the weekend and I will let you know.

    Thanks for your help! SdeDot

    Friday, May 11, 2012 6:21 PM
  • Blake,

    Your suggestion worked as well as the Get-Alert and Get-Monitor Powershell commands.

    Thanks for the help.


    Thanks for your help! SdeDot

    Thursday, May 17, 2012 10:11 PM
  • Happy to help.

    Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/

    Thursday, May 17, 2012 11:01 PM