locked
Exclude System Databases from Monitor RRS feed

  • Question

  • Hi,

    I have activated the Monitor: "MSSQL on Windows: Database - Auto Update Statistics Configuration". I chose Off instead of On as the expected value.

    How can I exclude the system DBs (master, model, msdb) from this monitor?

    BR

    Julian

    Thursday, August 13, 2020 3:20 PM

Answers

  • I haven't looked at the monitor, but what class does it target?  Find that.

    Then make a group, a dynamic group, that contains that class with a reg expression filter:

    Name matches regular expression ^(?i:master|model|msdb)$

    See if the group populates with all your master, model and msdb instances.

    If it does, then override that monitor for "other group" and disable.


    Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/ If my response was helpful, please mark it as so, if it answered your question, then please also mark it accordingly. Thank you.

    • Proposed as answer by CyrAz Thursday, August 13, 2020 7:25 PM
    • Marked as answer by Julian79 Friday, August 14, 2020 12:28 PM
    Thursday, August 13, 2020 6:35 PM
  • Hi Julian,
     
    Thanks for the reply. I am glad to hear that it is working now. Here, please let me write a summary for the issue:
     
    Issue Definition:
    ====================
    How to exclude the system DBs (master, model, msdb) from a monitor?
     
    Suggestions:
    ====================
    1. Make a group, a dynamic group, that contains that class with a reg expression filter:
        Name matches regular expression ^(?i:master|model|msdb)$
    2. See if the group populates with all the master, model and msdb instances.
    3. If it does, then override that monitor for "other group" and disable.
     
    Thanks for the time and have a nice day!
     
    Best regards.
    Crystal

    "SCOM" forum will be migrating to a new home on   Microsoft Q&A!
      We invite you to post new questions in the "SCOM" forum's new home on   Microsoft Q&A!
      For more information, please refer to the sticky post.


    Monday, August 17, 2020 1:38 AM

All replies

  • I haven't looked at the monitor, but what class does it target?  Find that.

    Then make a group, a dynamic group, that contains that class with a reg expression filter:

    Name matches regular expression ^(?i:master|model|msdb)$

    See if the group populates with all your master, model and msdb instances.

    If it does, then override that monitor for "other group" and disable.


    Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/ If my response was helpful, please mark it as so, if it answered your question, then please also mark it accordingly. Thank you.

    • Proposed as answer by CyrAz Thursday, August 13, 2020 7:25 PM
    • Marked as answer by Julian79 Friday, August 14, 2020 12:28 PM
    Thursday, August 13, 2020 6:35 PM
  • Hi,

    We can check if there's a parameter named Exclude List under the override Properties to exclude the master database. Or create a new class without this database. Here are some links for the reference.
    https://social.technet.microsoft.com/Forums/en-US/719857e1-3311-4af0-9b1e-e5b213fd4dc2/disable-discovery-of-certain-databases?forum=operationsmanagermgmtpacks
    https://kevinholman.com/2020/01/31/how-to-exclude-sql-express-edition-from-scom-monitoring/
    Note: non-Microsoft link, just for the reference.

    Hope it can help.

    By the way, this SCOM Forum will be migrating to a new home on Microsoft Q&A, please refer to this sticky post for more details.

    Best regards.
    Crystal     


    "SCOM" forum will be migrating to a new home on   Microsoft Q&A!
      We invite you to post new questions in the "SCOM" forum's new home on   Microsoft Q&A!
      For more information, please refer to the sticky post.

    Friday, August 14, 2020 2:18 AM
  • Hi Blake,

    I made a small mistake in my dynamic group. Now it's working. Thank you for your help.

    BR

    Julian


    • Edited by Julian79 Friday, August 14, 2020 12:28 PM
    Friday, August 14, 2020 11:15 AM
  • Noice!

    Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/ If my response was helpful, please mark it as so, if it answered your question, then please also mark it accordingly. Thank you.

    Saturday, August 15, 2020 5:54 AM
  • Hi Julian,
     
    Thanks for the reply. I am glad to hear that it is working now. Here, please let me write a summary for the issue:
     
    Issue Definition:
    ====================
    How to exclude the system DBs (master, model, msdb) from a monitor?
     
    Suggestions:
    ====================
    1. Make a group, a dynamic group, that contains that class with a reg expression filter:
        Name matches regular expression ^(?i:master|model|msdb)$
    2. See if the group populates with all the master, model and msdb instances.
    3. If it does, then override that monitor for "other group" and disable.
     
    Thanks for the time and have a nice day!
     
    Best regards.
    Crystal

    "SCOM" forum will be migrating to a new home on   Microsoft Q&A!
      We invite you to post new questions in the "SCOM" forum's new home on   Microsoft Q&A!
      For more information, please refer to the sticky post.


    Monday, August 17, 2020 1:38 AM