Creating custom User-defined Database Groups (4229519)

• Database Groups — includes by default the All list, and the Database Groups list, which serves as the parent group for creating user-defined sub-groups of database instances. Such sub-groups are recognized as Foglight services.The Database Groups section also displays the highest severity level of the database groups, under the column Sev.
• Services — displays the configured services, which contain at least one object (database topology) that y Foglight for SQL Server uses.
  All the Foglight for SQL Server sub-groups, which were created using the Database Groups section, are displayed also under Services. In addition, Services displays groupings of monitored resources that were created using the Service Builder dashboard, and contain Foglight for SQL Server database topology.
  The Services section also contains the column SLC (Service Level Compliance), which indicates the current availability of the selected service over a given period. For details about the Service Builder dashboard, see the Foglight Online Help.

The following video details how to create a custom user defined group of databases.

To create a database group:

1. In Foglight 6.0 and higher, navigate to the Databases dashboard and click the collapsing arrow next to All in the top left corner of the panel 

   

2. Select the parent database instance group, Database Groups, under Databases in the navigation pane.
3. Click the + button (icon).
   The Add Sub Group dialog box appears.
4. Type a name for the group in the Name field.
5. Type a description for the group (optional).
6. Select an instance in the Available column, and click [>] to move the instance to the Selected column.
   Alternatively, click [>>] to move all the databases to the Selected column.
7. Click OK.
   The sub-group name appears in the Database Groups list.
   The database instances are listed in the Databases dashboard.

After adding one or more user-defined sub-groups, it is possible to add sub-groups to these sub-groups.

To add sub-groups to a selected group:

1. Position the cursor on the requested group’s name.
2. Repeat Step 2 to Step 6 from above.

To remove a database sub-group:

1. Select the sub group to remove.
2. Click the X button (icon).
   The verification dialog box appears.
3. Click Remove.
   The sub-group is removed from the Database Groups list.

To edit a database sub-group:

1. Select the requested sub group.
2. Click the pencil button (icon). 
   The Edit Group dialog box appears.
3. To add an instance to the sub group, select the requested instance in the Available column and click [>].
   The selected instance moves to the Selected column.
4. To remove an instance from the sub-group, select the requested instance in the Selected column, and click [The selected instance moves to the Available column.
5. Click OK.