• 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

Calcuate traffic from ISA msde database

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> Calcuate traffic from ISA msde database Page: [1]
Login
Message << Older Topic   Newer Topic >>
Calcuate traffic from ISA msde database - 17.Mar.2010 7:40:06 PM   
georgeping

 

Posts: 8
Joined: 9.Jul.2009
Status: offline
I wrote on ISA server some store procedure scripts to calculate users (IP) traffic through ISA firewall to internet within a time range. I examed the FirewallLog fields, there are a lot of rows for userIP to ISA port 1745, and rows of source/destination network = localhost, and rows with differnt Result code, as well as different Action codes. etc.

Could some advice me the filters to calculate user's Internet receivedata and sentdata, like Rule="allowed traffic -such as http/https/ftp etc", Action code=?, Result code=? source network=? destination network=?

I just want to see, for example, how much a user downloaded or sent over internet, where it went, with what apps.

Please help. Thanks.
Post #: 1
RE: Calcuate traffic from ISA msde database - 19.Mar.2010 2:23:49 PM   
paulo.oliveira

 

Posts: 3472
Joined: 3.Jan.2008
From: Amazon, Brazil
Status: offline
Hi,

I think ISA reports provide this information to you (total bytes a user downloaded).

Regards,
Paulo Oliveira.

_____________________________

Microsoft Premier Field Engineer (PFE)
Blog: http://poliveirasilva.wordpress.com/
Twitter: https://twitter.com/poliveirasilva

(in reply to georgeping)
Post #: 2
RE: Calcuate traffic from ISA msde database - 30.Mar.2010 8:14:13 PM   
georgeping

 

Posts: 8
Joined: 9.Jul.2009
Status: offline
I am using ISA 2006. I just ran ISA Management > Monitoring > Reports, Then create a new report for yesterday, and all content to report, but there is nothing in the report: all charts and graphs showed blank.
Strange! I could generate a report years ago.
Anyway I'd appreciate anyone give me some advices to query the MSDE directly for example, last night 10pm to 11pm, which user is the biggest downloader...etc,

Thanks.

(in reply to paulo.oliveira)
Post #: 3
RE: Calcuate traffic from ISA msde database - 1.Apr.2010 8:17:29 AM   
aza

 

Posts: 9
Joined: 28.Mar.2002
Status: offline
All the data is in the MSDE database. You can either query yourself using SQL Server Management Studio Express and use Excel or you can try my freeware program that does exactly what you want.

The registered version also show the total bytes send/received per users.

http://www2.tech-mentor.com/uwr

Alain Hogue
Tech-Mentor inc.

(in reply to georgeping)
Post #: 4
RE: Calcuate traffic from ISA msde database - 1.Apr.2010 8:47:39 AM   
paulo.oliveira

 

Posts: 3472
Joined: 3.Jan.2008
From: Amazon, Brazil
Status: offline
Hi,

do you have the latest packs and patches installed on your ISA firewall? Also, run ISABPA to look for misconfigurations.

Regards,
Paulo Oliveira.

_____________________________

Microsoft Premier Field Engineer (PFE)
Blog: http://poliveirasilva.wordpress.com/
Twitter: https://twitter.com/poliveirasilva

(in reply to georgeping)
Post #: 5

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> Calcuate traffic from ISA msde database 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