In Progress - Not Complete

Last Modified on 10/05/2007.

 

Microsoft Log Parser found here:
http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx

Stone Steps Webalizer found here:
http://www.stonesteps.ca/projects/webalizer/

C:\scripts\createTrends.bat 

c:\scripts\LogParser -i:IISW3C -o:w3c "SELECT Date, * Into D:\webRoot\www.mojoportal.com\Data\Sites\4\logs\*.txt FROM <2048659957> WHERE (cs-Host Like '%%domainname.com%%') And (cs-uri-stem Not Like '%%/%%/%%') And (cs-uri-stem Like '%%.aspx%%') And Date >= SUB(To_Date(SYSTEM_TIMESTAMP()),TIMESTAMP('2','d'))"

c:\scripts\LogParser -i:IISW3C -o:w3c "SELECT Date, * Into D:\webRoot\www.mojoportal.com\Data\Sites\5\logs\*.txt FROM <2048659957> WHERE (cs-Host Like '%%summititsolutions.com%%') And (cs-uri-stem Not Like '%%/%%/%%') And (cs-uri-stem Like '%%.aspx%%') And Date >= SUB(To_Date(SYSTEM_TIMESTAMP()),TIMESTAMP('2','d'))"

for /f "tokens=6" %%i in ('c:\scripts\locate.com D:\webRoot\www.mojoportal.com\Data\Sites\4\logs\*.txt /np /l /D:T-1 ^| sort /+41') do call d:\temp\webalizer.exe D:\webRoot\www.mojoportal.com\Data\Sites\4\logs\\%%i -c D:\webRoot\www.mojoportal.com\Data\Sites\4\trends\webalizer.conf -F iis 

for /f "tokens=6" %%i in ('c:\scripts\locate.com D:\webRoot\www.mojoportal.com\Data\Sites\5\logs\*.txt /np /l /D:T-1 ^| sort /+41') do call d:\temp\webalizer.exe D:\webRoot\www.mojoportal.com\Data\Sites\5\logs\\%%i -c D:\webRoot\www.mojoportal.com\Data\Sites\5\trends\webalizer.conf -F iis