Forum Discussion

DGMalcolm's avatar
DGMalcolm
Iron Contributor
Feb 05, 2024

SCOM - Enable "Database Backup Status" monitor for select databases

Hey there,

I've got 8 SQL servers discovered in my environment and I'd like to enable the "Database Backup Status" monitor for all of the databases on 4 of those servers. I want to do this using a dynamic group so that I don't have to constantly manage the list of databases. I've tried several approaches but each of them has fallen short. Any thoughts on how I can approach this?

TIA

~dgm~

  • The process is as follows (assuming you are using the Console to create the group):
    Create a custom group; give it an appropriate name that ends with "Group".
    Example: "Spinco Production Databases Group".
    Define the custom group to dynamically include either the workflow target type: MSSQL on Windows: Database (Microsoft.SQLServer.Windows.Database) or a child class of the target type or the class type that hosts the target type; in this case the hosting class is: MSSQL on Windows: DB Engine (Microsoft.SQLServer.Windows.DBEngine). You can use any properties of the class types mentioned above to define your dynamic membership rule.
    Class graphs available here.
    Override the monitor for a group; specify your new group as the target.
    In which unsealed MP this group definition should be stored is a topic all on its own and is beyond the scope of this response but just keep in mind that the override must be stored in the same unsealed MP as the group.

    The best approach for overrides in general (according to this guy) can be found here: https://monitoringguys.com/2016/05/24/how-to-correctly-create-an-override-for-a-scom-workflow/. But unfortunately the guidance at the link doesn't go into detail about groups because it's a bit more complicated to explain.

    • DGMalcolm's avatar
      DGMalcolm
      Iron Contributor

      TysonPaul- Thanks for the assist. I wanted to automate this as much as possible and the DBA is known for adding databases at the drop of a hat. So I created a group of SQL servers first then I created another group that calls for any database that is associated with the servers in the first group. If any databases are added to these servers now, they should automatically be enabled for backup monitoring.

       

      Thanks again,

      ~dgm~

Resources