Showing posts with label logs. Show all posts
Showing posts with label logs. Show all posts

Tuesday, March 20, 2012

Report Builder Filter Newbie Question

Sorry for the newbie question.

I've just started building a report to display my IIS logs. I want to filter out all internal IP's, how would I do this?

Thanx

I've figured out NOT but how do I use a range of IP's?

Could I use a wild card

<>"192.168.1.*"

Or should I give it a range'

<>"192.168.1.1-192.168.1.254"

Thanx

|||

Try this

In Filter list

Use an expression instead of selecting the field/column itself like

if u have IPField

left(IPField,10) (this gives value - 192.168.1. (10 chars))

In Operator use != (Not equals)

In Value use an expression = "192.168.1."

Hope this helps u

Saturday, February 25, 2012

Report and Audit Controls from Log??

Can The SqlServer Log/LogArchives be used for reporting a change/audit history of important database fields?
Cand the Logs be used to lookup when and how often certain fields were/are changed...
Cnn the log be used as an Audit control to prove to the customer that he changed his oun fields by date and time? And Provide before and after images of changes by date and time...
You might want to look into the products offered by Lumigent.
(www.lumigent.com)
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"SqlBob" <rplewis@.mindspring.com> wrote in message
news:855EDBB3-1857-456F-91BD-DB51947B0BE4@.microsoft.com...
Can The SqlServer Log/LogArchives be used for reporting a change/audit
history of important database fields?
Cand the Logs be used to lookup when and how often certain fields were/are
changed...
Cnn the log be used as an Audit control to prove to the customer that he
changed his oun fields by date and time? And Provide before and after
images of changes by date and time...

Report and Audit Controls from Log??

Can The SqlServer Log/LogArchives be used for reporting a change/audit histo
ry of important database fields?
Cand the Logs be used to lookup when and how often certain fields were/are c
hanged...
Cnn the log be used as an Audit control to prove to the customer that he cha
nged his oun fields by date and time? And Provide before and after images
of changes by date and time...You might want to look into the products offered by Lumigent.
(www.lumigent.com)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"SqlBob" <rplewis@.mindspring.com> wrote in message
news:855EDBB3-1857-456F-91BD-DB51947B0BE4@.microsoft.com...
Can The SqlServer Log/LogArchives be used for reporting a change/audit
history of important database fields?
Cand the Logs be used to lookup when and how often certain fields were/are
changed...
Cnn the log be used as an Audit control to prove to the customer that he
changed his oun fields by date and time? And Provide before and after
images of changes by date and time...