How do I delete filters for Database Reports?

Article created 2005-05-03 by Hamid Ali Raja.

In order to delete a filter it's necessary that you have a previously saved report in which you had applied filters. Click on the following link if you wish to learn how to add filters for database reports. "How do I add filters for Database Reports?"

Lets say that you initially had applied the following filters

(  ( EventID is one of (500,1000,2000,3000) ) AND ( FromHost is not equal to WS01 ) )

                                                                AND

( ( EventSource is equal to Security ) OR ( Priority is greater than 5 ) )

and the filter form looked like this:

Lets say that you wish to delete some filters so that the condition string looks like:

(  ( EventID is not one of (500,1000,2000,3000) ) AND ( FromHost is not equal to WS01 ) )

You would have to follow the following steps in order to accomplish this.

1) Click on Priority Node in the tree view and click on the "Delete" button on the right. It will remove this node and the filter form will look like this:

If you notice the yellow text field at the bottom of this form, you will see that it is displaying exactly the same filter string that you intend to apply. In general deleting a node deletes all of its sub children as well.

Please note that in this case you don't need to have two different AND nodes in the tree view as shown in the above figure. 

3) If you now click on the generate report button, it will generate the report with the applied filters. However if you intend to generate this report with the same filters every day or quite often, then you should save the report by pressing on the Save Report button. This report will be saved under the "System Status Report" (for this example) in the Report Manager.

8) If you want to schedule this saved report with the same filters, you can do that too by going in the Job Manager