Browse by Tags

All Tags » Logparser (RSS)

Log Parser, unique page views and unique IP's by steve schofield

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 by steve schofield

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. by steve schofield

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 by steve schofield

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 by steve schofield

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. by steve schofield

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' by steve schofield

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 by steve schofield

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. by steve schofield

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 by steve schofield

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 »