• 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

ISA Logging problems

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> ISA Logging problems Page: [1]
Message << Older Topic   Newer Topic >>
ISA Logging problems - 2.May2006 1:27:26 PM   


Posts: 2
Joined: 2.May2006
Status: offline
Hy all,

I'm having this problem: ISA Server 2004 does not log the URL in an MS SQL Database. It logs the hostname (like www.yahoo.com) but not the entire URL (like www.yahoo.com/xxx/yyy). anyone had this problem? I mention that ISA Server 2004 SP2 is installed on the machine.


Post #: 1
RE: ISA Logging problems - 3.May2006 2:29:49 PM   


Posts: 50013
Joined: 10.Jan.2001
From: Texas
Status: offline
Are you using the Web proxy client configuration?



Thomas W Shinder, M.D.

(in reply to i_pacu)
Post #: 2
RE: ISA Logging problems - 10.May2006 3:01:19 PM   


Posts: 2
Joined: 2.May2006
Status: offline
Thanks for your answer Tom. It seems that this an issue in ISA Server 2004 SP2. Microsoft does not have an article to manage this problem. So, if you have ISA Server 2004 with SP2 and you log in an MSSQL database hte URL is not logged!!!!


(in reply to tshinder)
Post #: 3
RE: ISA Logging problems - 12.Jul.2006 1:50:29 PM   


Posts: 11
Joined: 5.Jan.2006
Status: offline
Is there anything new on this?  We would like to update to SP2, but certainly don't want to loose uri info

(in reply to i_pacu)
Post #: 4
RE: ISA Logging problems - 12.Sep.2006 10:39:06 AM   


Posts: 195
Joined: 8.Sep.2006
Status: offline
I am using a SQL server to log ISA and I do not have this issue.
In the SQL schema there are 2 fields named :

- DestHost
- uri

DestHost contains the destination host only, such as www.microsoft.com and,
uri contains the full url the guy has visited such as : www.microsoft.com/mcp/learning.asp

I do not know if those fields exists in the MSDE or text logs

(in reply to NoneAndOne)
Post #: 5
RE: ISA Logging problems - 18.Oct.2006 10:56:39 AM   


Posts: 2
Joined: 18.Oct.2006
Status: offline
Are you using SQL Enterprise Manager to view the log?
It has a limit on max chars to show and that might be causing it.

Instead try to use Query Analyzer to view the uri field, setting the max chars per column to 2048 under Options->Results.

hope it helps

(in reply to Boedus)
Post #: 6

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> ISA Logging problems 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