Welcome to ISAserver.org

Create Query/Report to show sites/searches of User

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Create Query/Report to show sites/searches of User

Page: [1]

Message

<< Older Topic Newer Topic >>

Create Query/Report to show sites/searches of User - 20.Nov.2005 1:31:59 PM

andrewmanning84

Posts: 18
Joined: 14.Oct.2005
Status: offline

I want to be able to create a report that can be emailed to someone every week which will show sites that users have visited if then contain certain words etc (e.g. sex, porn...)

I know how to create the report and have it emailed but am unsure how to create the query for this.

Any help would be great

Post #: 1

Featured Links*

RE: Create Query/Report to show sites/searches of User - 20.Nov.2005 4:56:30 PM

tshinder

Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline

Hi Andrew,

For this type of granular reporting, you'll be better off using a 3rd party reporting app.

HTH,
Tom

_____________________________

Thomas W Shinder, M.D.

(in reply to andrewmanning84)

Post #: 2

RE: Create Query/Report to show sites/searches of User - 21.Nov.2005 9:27:58 PM

andrewmanning84

Posts: 18
Joined: 14.Oct.2005
Status: offline

Cheers Tom

Can you or anyone recommend one? I have used SurtControl in the past but this is expensive for what my user wants it for.

It is to be used in a school environment where the administrator can log what sites certain "naughty" kids are going on.

All suggestion would be great so I can check them out

Thanks

(in reply to tshinder)

Post #: 3

RE: Create Query/Report to show sites/searches of User - 24.Nov.2005 5:50:47 PM

wishfly

Posts: 122
Joined: 6.Mar.2005
Status: offline

you can try this software -- netfee for ISA server

http://www.netfeesoftware.com/NetFee/Index.htm

(in reply to andrewmanning84)

Post #: 4

RE: Create Query/Report to show sites/searches of User - 8.Jan.2006 5:32:58 AM

J.F.

Posts: 43
Joined: 28.Nov.2005
Status: offline

Hi Andrew:

You can also script this yourself, if you want to put some elbowgrease into it, by using SQL queries against your ISA logs with Microsoft's free (and wonderful!) Log Parser tool (see www.logparser.com). For a bunch of sample queries, see inside the script named "ISA_LogParser.vbs" at www.ISAscripts.org. This requires some knowledge of SQL query syntax, though, and the logs must be in textual format. If you wanted to batch script it out, I'm sure you could figure out some likely keywords that FINDSTR.EXE or a Windows version of GREP.EXE could find. Overall, though, a commercial third-party app will be the easiest to use.

Cheers,
JF

(in reply to wishfly)

Post #: 5