Previous Next

• 07-17-2007, 9:45 AM

  Spelloyal Joined on 07-17-2007, 1:41 PM Posts 5

  Charting bandwidth untilization usage via IIS6, ASP and IIS log files. Reply Contact I would like to create graphs similar to the ones produced by RRDtool using my IIS6 logs. Most of the solutions I have researched are either UNIX based or require an alternate other than IIS. I would like something that can be used with IIS and ASP with the IIS logs as the source. The end result I want to achieve is to know how much bandwidth utilization individual sites on an IIS6 box are using. For example, "Site [X] utilized an average of [Y].[Z] megabits of bandwidth over the past month". Can anyone provide some insight on a course of action or a software product? Something similar to Cacti (operating under IIS/ASP) would be ideal. As an alternative to this question, is there a formula I can use to derive the megabits per second transfer rate from IIS logs assuming I have access to the logs via ASP or SQL.

  Tags: IIS 6.0ASP Classic

• 07-17-2007, 2:22 PM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Lawrenceville, NJ Posts 4,038	Re: Charting bandwidth untilization usage via IIS6, ASP and IIS log files. Reply Contact AWStats will give you this number.  It's free, based on PERL, and works with IIS. http://awstats.sourceforge.net/ Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/

• 07-17-2007, 2:50 PM

  In reply to

  Spelloyal Joined on 07-17-2007, 1:41 PM Posts 5

  Re: Charting bandwidth untilization usage via IIS6, ASP and IIS log files. Reply Contact Hi, Thanks for the link. This seems like a good product, but there's two things that make it unsuitable for my needs. First, it does not have the report that I am looking for which is something similar to the one in the image below: http://cacti.net/get_image.php?image_id=43&x=640&y=568&quality=90  Second, I am looking for something that works under ASP/IIS6. Thanks

• 07-17-2007, 3:40 PM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Lawrenceville, NJ Posts 4,038

  Re: Charting bandwidth untilization usage via IIS6, ASP and IIS log files. Reply Contact You could use LogParser to write custom SQL queries against the logs to get that data and then generate a graph. http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1287 Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/

• 07-18-2007, 3:08 PM

  In reply to

  Spelloyal Joined on 07-17-2007, 1:41 PM Posts 5

  Re: Charting bandwidth untilization usage via IIS6, ASP and IIS log files. Reply Contact Re: Charting bandwidth untilization usage via IIS6, ASP and IIS log files. Hi, Thanks for the logparser recommendation. I used it and it has pushed me in the right direction. I used the following line to output some numbers. LogParser "SELECT TO_TIMESTAMP(date,time) , sc-bytes, cs-bytes, time-taken , cs-host INTO h:\temp\output.csv FROM h:\temp\log.log" -q:ON Specifically, I outputted the time, bytes and time taken from the log file. I then added up the bytes (down and up), converted the bytes to megabits and then divided by the time taken. Can you confirm my math to derive the average megabits per second: Megabits Total: 27.9159698486328000 Seconds total: 343.583 Megabits per second average: 0.081249567 (megabits divided by time) The only problem I ran into is that my FTP server (SERV-U) does not output a log in a format that logparser can read so I am stuck there.

• 07-18-2007, 3:46 PM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Lawrenceville, NJ Posts 4,038	Re: Charting bandwidth untilization usage via IIS6, ASP and IIS log files. Reply Contact Yes, that division is correct. Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/