Log Parser, unique page views and unique IP's
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 … more
Contents tagged with Logparser
Logparser – look for certain IP's between a timeframe
Here is a quick example of pulling certain ip’s from the IIS Logs. ‘Specific log filelogparser “select top 10 count(*),c-ip from d:wwwlogsw3svc2u_ex010228.log where … more
Log Parser – Select IIS log entries between timeframes.
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 … more
Log parser forums are back online
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 … more
Searching logfiles with Powershell, Log parser, Findstr, QGrep
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 … more
Log parser looking for items in cs-uri-query example.
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 … more
Logparser and finding information 'between two times'
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 … more
Extract TOP 10 – '500 errors' from IISLogs using Logparser
SELECT TOP 10 cs-uri-stem, sc-status, count(*) INTO filename_top10_500.csv FROM \ServerNamePathToWWWlogsw3svcSITEIDexYYMMDD.log where sc-status=500 group by cs-uri-stem,sc-status order by count(*) … more
Find top 10 requests using Log Parser.
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 … more
Count number of downloads using Logparser
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 … more
Search
RSS