• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

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]
Login
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
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

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> Create Query/Report to show sites/searches of User Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts