SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Report filter functions

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Report filter functions
Author Message
Cheri G



Joined: 08 Nov 2005
Posts: 10

Post Report filter functions Reply with quote

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

Thu Apr 13, 2006 7:08 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Report filter functions Reply with quote

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

Thu Apr 13, 2006 7:22 pm View user's profile Send private message
Cheri G



Joined: 08 Nov 2005
Posts: 10

Post Re: Report filter functions Reply with quote

I tried this and got the same error
though - is this in version 3.0 maybe?
I've just implemented version 2.7 and looking to
upgrading now.

And we have tried some of the other options,
which are great to have.
I'm just trying to keep this all in one
tool to minimize how much hopping around the
people who produce & look at the output have to do.

Thanks!

: 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.

Thu Apr 13, 2006 8:08 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Report filter functions Reply with quote

I just tried that and found it working when every part is in brakets

(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%')

Hope this helps.

: I tried this and got the same error
: though - is this in version 3.0 maybe?
: I've just implemented version 2.7 and looking to
: upgrading now.

: And we have tried some of the other options,
: which are great to have.
: I'm just trying to keep this all in one
: tool to minimize how much hopping around the
: people who produce & look at the output have to do.

: Thanks!

Thu Apr 13, 2006 9:08 pm View user's profile Send private message
Cheri G



Joined: 08 Nov 2005
Posts: 10

Post Re: Report filter functions Reply with quote

: I just tried that and found it working when every part is in brakets

: (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%')

: Hope this helps.

Excellent - thanks very much, this worked!

Thu Apr 13, 2006 9:29 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.