locked
Exporting a list of all possible alerts RRS feed

  • Question

  • Hello All,

    I am looking to see if there is a way to export all possible alerts that can be sent out for each management pack?

    I've been searching and the only thing I can find is a way to export all active alerts.

    Thanks,

    Tom


    Thanks, Thomas Hughes

    Wednesday, January 28, 2015 9:45 PM

Answers

All replies

  • if you want to get the list of all alerts that can be generated from a MP then you will need to open that MP through "MP Silect" or "SCOM 2007 Authoring console" and check out all the RULES and MONITORS. They will give you the information of all the possible alerts that will come from that MP.

    If you open in MP Silect, then you can also use "Export to csv" feature to export all the Rules and Monitors.

    Refer this link for detailed information - http://blogs.technet.com/b/stefan_stranger/archive/2010/11/30/what-monitors-rules-and-discoveries-are-running-on-an-opsmgr-agent.aspx

    http://www.concurrency.com/infrastructure/export-management-pack-rules-and-monitors-from-scom-2012/

    Powershell command to get the list of all rules ==

    get-rule | select-object @{Name="MP";Expression={ foreach-object {$_.GetManagementPack().DisplayName }}},DisplayName | sort-object -property MP | export-csv "c:\rules.csv"

    Powershell command to get all the monitors listed =

    get-monitor -managementPack name.mp | export-csv filename


    Thanks, S K Agrawal



    • Edited by S K Agrawal Thursday, January 29, 2015 5:06 AM
    • Marked as answer by Thomas Hughes Thursday, January 29, 2015 6:28 PM
    Thursday, January 29, 2015 5:02 AM
  • If you has right on SQL, you should consider using the following SQL statement to extract Alerts which are send out by each Management Pack.

    *************************************************************

    select managementpack.mpfriendlyname, alertview.* from
    alertview inner join rules
    on alertview.monitoringrulid=rules.ruleid
    inner join ManagementPack on
    rules.ManagementPackID=ManagementPack.ManagementPackId
    where ManagementPack.MPFriendlyName='XXXXXXX'
    union
    select managementpack.mpfriendlyname, alertview.* from
    alertview inner join monitor
    on alertview.monitoringrulid=Monitor.MonitorId
    inner join ManagementPack on
    Monitor.ManagementPackID=ManagementPack.ManagementPackId
    where ManagementPack.MPFriendlyName='XXXXXXX'

    ************************************************

    Roger

    Thursday, January 29, 2015 5:38 AM
  • Hi,

    You may try below powershell script to find all monitors and rules in specific MP which may generate alerts:

    Get-SCOMManagementPack -DisplayName "*MPNAME*" |Get-SCOMMonitor | where { $_.AlertSettings -ne $null}

    Get-SCOMManagementPack -DisplayName "*MPNAME*" |Get-SCOMRule | where { $_.AlertSettings -ne $null}

    Regards,

    Yan Li


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, January 29, 2015 8:39 AM
  • Thanks S K Agrawal, these are exactly what I could find.  Much appreciated.


    Thanks, Thomas Hughes

    Thursday, January 29, 2015 6:29 PM