How do I update filters for Database Reports?
Article created 2005-05-03 by
Hamid Ali Raja.
In order to update 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 update this filter condition string to this now:
( ( EventID is not one of (500,1000,2000,3000) ) AND ( FromHost is not equal
to WS01 ) )
OR
( ( EventSource is equal to Security ) OR ( Priority is greater than 5 ) )
You would have to follow the following steps in order to accomplish this.
1) Click on the top most AND node in the tree view and click on "Change
Operator Button" until it becomes OR. Your filter form will look like this
2) Select on "EventID" node in the tree view and change the "Select Operator"
combo box value to "is not one of" and click on "Set Value" button and you are
done. Your 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.
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
|
