Browse by Tags

Log Parser, unique page views and unique IP's
26 March 08 11:18 PM | steve schofield | with no comments

I've been working with Log parser lately and wanted to pass along a couple queries. I have a in-depth filter that involved using three Log parser functions ( EXTRACT_EXTENSION , EXTRACT_FILENAME , EXTRACT_PATH ). Each have their own purpose but combined...

Filed under: Logparser

Logparser - look for certain IP's between a timeframe
28 February 08 02:05 PM | steve schofield | 1 comment(s)

Here is a quick example of pulling certain ip's from the IIS Logs. 'Specific log file logparser "select top 10 count(*),c-ip from d:\wwwlogs\w3svc2\u_ex010228.log where to_time(time) between timestamp('01/01 13:50:00', 'MM/dd hh:mm:ss') and timestamp...

Filed under: Logparser

Log Parser - Select IIS log entries between timeframes.
21 January 08 09:52 PM | steve schofield | 2 comment(s)

I recently needed to select all IIS log entries between a specific timeframe. Log parser to the rescue! Here are a couple of examples I used. 'Change the location of files right after the timeframe.'Change the location of files right after the timeframe...

Filed under: Logparser

Log parser forums are back online
24 August 07 08:30 AM | steve schofield | 1 comment(s)

After a brief absence, the forums for Log parser are back online. Thanks a bunch to the IIS team for making this resource available. http://forums.iis.net/default.aspx?GroupID=51 What is Log parser? http://www.logparser.com Where do I get log parser?...

Filed under: Logparser

Searching logfiles with Powershell, Log parser, Findstr, QGrep
25 January 07 02:19 PM | steve schofield | 2 comment(s)

I'm on a mission! I have to search log files that are between 150 MB and larger. These are syslogd files generated. Here is sample output. 2007-01-15 00:00:10 Mail.Debug 111.111.111.111 join[00000]: server.steve.net[1.1.1.1] 1168837209-0ff301650000...

Filed under: Logparser, powershell

Log parser looking for items in cs-uri-query example.
15 January 07 10:22 PM | steve schofield | 2 comment(s)

Here is a command using Log parser to retrieve a specific value in the cs-uri-query item. LogParser -I:iisw3c "SELECT * INTO Filename.csv FROM \\ServerName \\ServerName \ShareName\W3SVC111\*.log where cs-uri-query Like '%http://bc0.cn/1.js%'"...

Filed under: Logparser

Logparser and finding information 'between two times'
20 December 06 07:06 PM | steve schofield | 1 comment(s)

I'm finding working with Logparser and dates is a bit involved. Here is a query I used to extract files between two times stored in W3SVC logs. logparser "select date,time,cs-uri-stem,sc-status,count(*) into out.txt from \\Server\wwwlogs\w3svcXXXXX...

Filed under: Logparser

Extract TOP 10 - '500 errors' from IISLogs using Logparser
14 December 06 03:07 PM | steve schofield | with no comments

SELECT TOP 10 cs-uri-stem, sc-status, count(*) INTO filename_top10_500.csv FROM \\ServerName\PathToWWWlogs\w3svcSITEID\exYYMMDD.log where sc-status=500 group by cs-uri-stem,sc-status order by count(*) DESC"

Filed under: Logparser

Find top 10 requests using Log Parser.
14 December 06 02:55 PM | steve schofield | 2 comment(s)

I've been using Logparser and posting some common used Queries. SELECT TOP 10 cs-uri-stem, COUNT(*)FROM "REPLACE_WITH_PATH_TO_LOGFILES_IIS_formats_logs_exYYMMDD.log" GROUP BY cs-uri-stem ORDER BY COUNT(*) DESC

Filed under: Logparser

Count number of downloads using Logparser
11 December 06 11:39 PM | steve schofield | with no comments

Time to time I use Logparser to extract information from IISLogs. Here is a query to extract the top 10 downloads. logparser.exe "select top 10 count(*) as hits, cs-uri-stem from ex*.log where cs-uri-stem like '%.zip%' group by cs-uri-stem...

Filed under: Logparser