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
|