In the tree structures that you will find throughout dbWatch there are 2 components that lets you group and filter instances.
On the top of the tree you have a “Grouping” panel that is minimized by default, and below that you have the quick text based filter.
The text filter works by removing all branches of the tree that do not have a node matching the filter.
In the example below, we type in “Must” and all instances except the one called “Mustafar” are removed.
The text filter is not restricted to instance names, all nodes in the tree are considered. For example typing “Back” will remove all branches that do not contain that text. In our case that will leave only instances with an alert named something with “backup”, and also remove all other alerts.
When the tree is a “status tree” (statuses propagate in the tree), the filtering will also result in the propagated statuses changing. For example if an instance has 2 alerts, a backup alert with status warning and a disk space alert with status alarm, the worst status will propagate to the instance (in this case alarm). The if you type “backup” in the filter box, the disk space alert will dissapear and the instance status will change to warning.
You can change the grouping by selecting a new predefined grouping definition in the drop down. You can also create new grouping definition as we shall see shortly.
The group by panel contains a list of properties that the instances in the tree are to be grouped by. In the example above, you see that we are grouping by two properties, server and group. This corresponds to the nodes in the tree. The top node is the Server (we only have one in this case) and on the next level we have the groups (Development, Production and Test).
You can add properties by typing them in the textfield and clicking the pluss sign.
For example if we type in “databasetype”, we see that the database types appears as a new level in the tree.
The order of the groupings can be rearranged by drag and drop in the list. You can remove them again by right clicking and selecting “Delete”.
You can save the new grouping definition by clicking “Save”, it will then replace the definition selected in the dropdown on the top.
You can save it as a new definition by clicking “Save as” and typing in a new name.
This dynamic grouping is an extremly powerfull feature that allows us to dynamically change your entire view of your environment.
For example, we can remove all the properties (right click on them and click delete) then add “task” (type task in the textbox and hit enter or click “+”).
Now we see that our instances are grouped by what tasks they have installed. For example we can see that only Alderaan has the “Job Scheduling check” installed.
In another example, we group by customer.
And we see that “Alderaan”, “Besbin” and “Crait” belongs to “Customer A” and another set of instances belongs to “Customer B”. Also notice that instances that do not have a defined customer are grouped directly under the group node.
All properties defined on instances can be used to group by. See the section on the Property System for details.
The metadata filter is more powerfull than the simple text filter and allows you to filter instances based on all the properties available on the instance.
In the example below we state that only Oracle instances with a host starting with “10.0.” in their address should be visible.
The lines in the metadata filter correspond to filters that can used in Dbwql queries for instances (The part in the square brackets). Read more about Dbwql and its syntax.
To see all the available properties that can be used in the metadata filter, open the Dbwql Console and type “instance/” and press the tab key.