You can use the following in the report side filter after you retrieve the data: text like 'ACTION%' and (text not like '%BACKUP%') and (text not like '%CONNECT%') and (text not like '%backup controlfile%') and (text not like '%dbms_stats%') and (text not like '%analyze%') You can also export report to a file, for example, an Excel file, and apply filters there You can also run a direct query in the database and use Oracle SQL filters in the query. : Is it possible in the front-end filtering : options of a report to have multiple criteria : based on the same field? : something like this? It's valid Oracle syntax : however the tool throws an error : "expecting TRUE/FALSE expression" : text like 'ACTION%' : and text not like '%BACKUP%' : and text not like '%CONNECT%' : and text not like '%backup controlfile%' : and text not like '%dbms_stats%' : and text not like '%analyze%' : We need some way to filter out all of the : extra lines created by loading the SYS : audit trace files into the database on the : User Activity Report (SYS Admins). : Thanks
|