Object Groups are useful when you need to apply similar policies to a set of objects that don't exist within the same hierarchical group in your SQL Sentry environment. These objects could be dispersed throughout your environment in different sites, groups, or subtrees, but if they share a similar set of characteristics, they may be ideal candidates for a similar set of policies.
Take for example all of the transaction log backup jobs within your environment. You may wish to suppress Runtime Threshold alerts generated when these jobs run by disabling the Send Email action. Object Groups allow you to do this without affecting any other agent jobs. In the past, this would involve you having to go and touch each of the transaction log backup job settings individually. Object Groups allow you to avoid the tedious process, saving you time because you can quickly locate objects by name or category, add them to a group, and apply a set of policies.
As Object Groups exist outside of the normal SQL Sentry hierarchy, a condition or setting configured for an Object Group is applied last after any inherited or explicitly defined condition or setting. In this way, Object Group conditions and settings have the final say within your environment.
As mentioned earlier, typical uses include disabling Runtime Threshold alerts for all transaction log backup jobs and applying policies to QA servers that may exist within several sites of your environment. When you create an Object Group, you choose how configured conditions and settings are applied in the group. You can create an ObjectGroup in which configured conditions and settings apply strictly to the group members. Alternatively, you may create an Object Group in which configured conditions and settings apply to the group members and their children. For more information, see the following section Creating New Object Groups.
Each Object Group you create also has an associated evaluation order. This evaluation order is specific to just the set of Object Groups in your environment. This is valuable when you have an object that belongs to multiple Object Groups with a divergent set of policies. The evaluation order allows you to control which group's configured conditions and settings are applied. A configured setting or condition from the ObjectGroup with the highest evaluation order will be applied last, and therefore will be the effective setting or condition. For example, if you have ten object groups, with orders 1 through 10, then 10 will be the highest/last applied.
When you add new objects to an ObjectGroup, any setting that is applicable to that object type will be configurable in the Settings pane. By default, each object in an ObjectGroup still receives its base set of inherited settings from its parent objects in the SQL Sentry hierarchy. If you would like to override these settings, define a setting within the ObjectGroup itself. Change the Defined setting to True. After you define a setting for an ObjectGroup, that setting is reflected in any applicable objects that belong to that group.
Just like settings, condition/action combinations become available as appropriate when objects are added to a group. With any ObjectGroup selected, you can configure conditions through the Conditions pane. For more information, see the following section Configuring Conditions and Settings for an Object Group.
To create a new Object Group, complete the following steps:
1. Double-click the Object Groups node in the Navigator pane to open the Object Groups Editor window.
2. Select Add in the Groups section of the Object Groups Editor window to open the Add Group dialog window.
3. Enter a name and description for the group. Also take note of the Applies To drop-down box. The following options are available:
|Selected group members and their children
|Any conditions or settings you configure for the group also apply to the children of the group members. This makes the group's settings and conditions inheritable.
|Selected group members only
|Any conditions or setting you configure for the group only apply to the specific members of the group and have no effect on their children. This makes the group's settings and conditions noninheritable.
If you're creating an ObjectGroup to set policies for just a finite set of objects and do not wish to impact or have access to children of the object, choose Selected group members only. Given the transaction log backup job use case discussed earlier, it wouldn't matter which Applies To option you chose because the agent job object is a leaf node in the SQL Sentry hierarchy.
4. Select Ok to add your Object Group.
To add new members to a group:
1. Select a group in the Groupssection of the editor window, and then select Add in the Group Memberssection of the editor window.
2. In the Select Group Members dialog screen, choose the object type of the group member you'd like to add from the tree view, and then select Search to view objects of that type in your monitored environment.
3. Select an object, and then select OK to add it to the group.
Once you've added your desired objects to the group, you can begin configuring the conditions and settings for the group. Configure conditions and settings, through the Conditions and Settings pane. If you don't see the Conditions and Settings pane, use the View (View > Conditions) menu to open it.
To add a condition to a group, complete the following steps:
- Select Object Groups in the Navigator Pane, and select the desired Object Group.
- Open the Conditions pane, and then select Add to open the Actions Selector window.
- Choose your desired condition/action combinations, and then select OK.
Alternatively, you can view this information directly at the individual object level. Select the desired object in the Navigator pane, and then open the Settings pane. The Inherent From Parent section of each setting group contains the name of the superior object that is passing down that group of settings. In the case where the object's setting has been defined with an Object Group, it lists that Object Group as the parent.