ok, i resolve in this mode on .bat: @ECHO OFF ECHO %DATE% echo >%temp%.\tmp.vbs y = DateAdd("d",-1,now) echo>>%temp%.\tmp.vbs m = CStr(Month(y)) echo>>%temp%.\tmp.vbs m = CStr(Right("0"+m,2)) echo>>%temp%.\tmp.vbs d = CStr(Day(y)) echo>>%temp%.\tmp.vbs d = CStr(Right("0"+d,2)) echo>>%temp%.\tmp.vbs y...

Thank you for the clarification. Just so I'm clear, the example you posted would search from 1:50 PM to 6:30 PM. I realize the IIS logs are stored in GMT. It was confusing some of the examples I was reading mentioned LP would convert it. Thanks again, I'll have to work with this some more so I'm confortable...

The TIMESTAMP method by itself does not have any notion of time zone. The TO_TIME method (which is actually unnecessary in your use above) has no concept of time zone either. Basically, the only methods of LP that deal with timezone would be the SYSTEM_ time functions and the TO_UTCTIME and TO_LOCALTIME...

Use the SUB method on date objects. Search the forums for tens of examples.

Sorry, i need insert yesterday date : "C:\Programmi\Log Parser 2.2\LogParser.exe" "SELECT COUNT(cs-uri-stem) FROM E:\log1\ex*.log WHERE cs-uri-stem like '/Download/it/ConfigAliceMessenger.exe%' AND date=*****YESTERDAY DATE IN THIS FORMAT YYYY-MM-DD******** " -q >YESTERDAY DATE IN THIS FORMAT YYYY-MM...

I'm searching IIS logs for data between times. I'm not sure if the time used to query is converted to GMT or not. Can someone confirm if 7:50 AM should be listed in the query as 13:50:00 or 07:50:00? logparser "select date,time,cs-uri-stem,sc-status,count(*) into out.txt from \\Server\wwwlogs\w3svcXXXXX...

Hello, I am stuck with a problem that I cannot think through. I need to parse our IIS logs every 5 minutes looking for a specific string and if that string is found to email the other members of our support staff. Our logs are generated daily so are in the format ex<date>.log. What I have come...

Hi, I am parsing IIS log and sometimes with the switch -e:1000 I get some errors displayed as follows ************************************************ Cannot find end-of-line - extra characters detected at the end of log entry LogFile " \\WEBserver\LogFiles\W3SVC2\ex061211.log ", Row number 411810 *...

Try: "select FULLURL Using STRCAT(cs-host,STRCAT(cs-uri-stem, REPLACE_IF_NOT_NULL(cs-uri-query, STRCAT( '?', cs-uri-query )))) AS FULLURL"

Please bear with yet another newbie to Logparser... I have been given the task of creating a method using LogParser that will extract the number of hits to the htm and htrml pages on our sites (we have about 75 to date) and insert the data into an SQL DB on a daily basis. I should add that the sites...