« Previous Next »

• 04-15-2009, 3:37 PM

  osahaf Joined on 04-15-2009, 3:11 PM Posts 2	How to write daily Bandwidth usage in SQL table Reply Contact I need help with an automated batch job that writes hourly bandwidth usage from previous day log file. More specifcally, how do dynamically generate the file name for my query. Any help will be appreciated.
  	Tags: date file checkbandwidthlogparseroutput

• 04-17-2009, 11:58 AM

  In reply to

  osahaf Joined on 04-15-2009, 3:11 PM Posts 2

  Re: How to write daily Bandwidth usage in SQL table Reply Contact Following query gives me the result I want but I still need help with a script that will process only the newer log files. C:\Program Files\Log Parser 2.2>logparser -i:IISW3C "Select QUANTIZE(TO_LOCALTIME(TO_TIMESTAMP(date,time)),3600) As Hour, Div(Sum(cs-bytes) ,1024) As Incoming(K), Div(Sum(sc-bytes),1024) As Outgoing(K) From C:\Temp\ex*.l og Group By Hour" -o:NAT