Exporting a list of all possible alerts

All replies

• 

  

  1

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  Thanks S K Agrawal, these are exactly what I could find.  Much appreciated.

  ---

  Thanks, Thomas Hughes

  Thursday, January 29, 2015 6:29 PM