How to create an alert view with NOT INCLUDING SQL alerts only from limited SQL Database Servers (OS related alerts to be displayed for these DB servers)?

• Tuesday, April 24, 2012 8:04 PM

   

   
  

  0

  Hi,

  I want to create a view with all the alerts only by EXCLUDING "SQL alerts for limited servers" (Note: OS related alerts to be displayed for these DB servers on the view).

  After going through below forum, I got an idea to create a group for limited SQL Servers based on "SQL DB Engine" and then exclude this particular group on another New Group named "ALL excluding Few SQL Servers" including all the other groups exists in my environment.

  http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/e77e41ce-e29d-4ca5-a428-d2939294eb53/

  Questions:

  1. Is using "SQL DB Engine" is enough to have all SQL related alerts. Because I could see many SQL related components in SCOM while creating Group like below. Please help me to select Correct Group.

  

  2. After creating a VIEW by using New Group ("ALL excluding Few SQL Servers"), will that exclude SQL alerts for limited servers here? I doubt because, basic SQL groups like (SQL Role, SQL Component, SQL DB, SQL DB Engine, etc.,) are already included on "ALL excluding Few SQL Servers". So, Will they still include SQL alerts for limited servers in this view? Please help me to achieve this requirement.

  Thanks,

  Suresh

  ---

  Regards, Suresh

  • Reply
  • Quote