IIS
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsSystem AdministrationIIS

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old January 17th, 2006, 10:59 AM
Noodles23's Avatar
Noodles23 Noodles23 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Location: Auckland, NZ
Posts: 423 Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)  Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2
Time spent in forums: 2 Days 22 h 38 m 26 sec
Reputation Power: 387
IIS6 logging

Is there any way of changing the order of the columns in the IIS6 log? I'm trying to merge data from IIS5 and IIS6 for awstats, but awstats cannot recongize both (as it's setup for IIS5)

Can anyone help?

Reply With Quote
  #2  
Old January 18th, 2006, 04:36 PM
Doug G Doug G is online now
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
 
Join Date: Jun 2003
Posts: 10,796 Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 15 h 3 m 30 sec
Reputation Power: 746
I don't have a clue on this one, sorry.

Maybe try altering the stats program rather than iis?
__________________
======
Doug G
======
"Hide, hide witch! The good folk come to burn thee. Their keen enjoyment hid behind their gothic mask of duty." -Mark Clifton

Reply With Quote
  #3  
Old January 19th, 2006, 09:30 AM
Noodles23's Avatar
Noodles23 Noodles23 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2004
Location: Auckland, NZ
Posts: 423 Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)Noodles23 User rank is Major (30000 - 40000 Reputation Level)  Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2Folding Points: 798763 Folding Title: Super Ultimate Folder - Level 2
Time spent in forums: 2 Days 22 h 38 m 26 sec
Reputation Power: 387
Found a crude but adequate solution

There's a tool in the IIS6 resource kit called logparser that has the ability to read in logs, transform them and spit them out again

Here's the batch file I came up with:

Code:
@echo off
for /f "tokens=1-3 delims=/ " %%a in ('doff mm/dd/yy -1') do (
set mm=%%a
set dd=%%b
set yy=%%c)
@echo on
cd "c:\logs\w3svc1\"
"c:\program files\iis resources\log parser\logparser.exe" -i:IISW3C -o:W3C "Select date, time, c-ip, cs-username, s-ip, s-port, cs-method, cs-uri-stem, cs-uri-query, sc-status, sc-bytes, cs-bytes, time-taken, cs-host, cs(User-Agent), cs(Referer) From ex%yy%%mm%%dd%.log to ez%yy%%mm%%dd%.log"


I run this batch file at 12:10am (10 mins after IIS has rolled over to the next log file)

IIS6 Resource kit: http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
LogParser (standalone): http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en
Doff (used for grabbing yesterday's date): http://www.jfitz.com/dos/

Reply With Quote
  #4  
Old January 19th, 2006, 05:54 PM
Doug G Doug G is online now
Grumpier Old Moderator
Dev Shed God 12th Plane (10500 - 10999 posts)
 
Join Date: Jun 2003
Posts: 10,796 Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level)Doug G User rank is Major General (70000 - 90000 Reputation Level) 
Time spent in forums: 1 Month 15 h 3 m 30 sec
Reputation Power: 746
Thanks for posting your solution!

Reply With Quote
Reply

Viewing: Dev Shed ForumsSystem AdministrationIIS > IIS6 logging


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway