How to get a SQL/CSV list of SCOM alerts and rules

• webrunner

  SSC-Dedicated

  Points: 31731

  More actions

  August 31, 2021 at 2:52 pm

  #3925481

  Hello experts,

  I've been tasked with tuning SCOM alerts for our database environment. Getting the alerts in emails is a little overwhelming and hard to manage.

  I don't see a way to export a list from the SCOM console, where I have to click through alerts one by one.

  Does anyone know how I can get a list of the possible alerts and rules that SCOM has set up, so I can create a table to organize them and categorize their severities according to our needs? I don't know if it makes a difference, but I want to extract a list from both the general Windows alerts and also the SQL Management Pack that our system admins installed.

  Thanks for any help.

  -- webrunner

  • This topic was modified 2 years, 8 months ago by  webrunner.

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  September 1, 2021 at 3:10 pm

  #3925874

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.