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 - 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:
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:
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:
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: ,
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 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:
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:
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:
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:
More Posts Next page »

This Blog

News

Blogs

Hosting Needs

Misc components

Misc Links

Syndication