Using LogParser 2.2 to Parse IIS Logs and Other Logs: ASP Alliance

ASP.NET Tutorials » Using LogParser 2.2 to Parse IIS Logs and Other Lo...

Not Logged In. Login

AspAlliance
Register
Edit My Profile
Author List
Write for Us
About AspAlliance
Contact Us
Privacy Policy
Link To Us
Advertise

Subscribe
Free Newsletter
Newsletter Archive
RSS Syndication

.NET Tutorials
Learn .NET
Learn WCF
Learn WPF
Learn ASP.NET
Learn AJAX
Learn Silverlight
Learn Visual Studio
Learn ADO.NET
Learn LINQ
Learn C# (CSharp)
Learn VB.NET
Learn Web Services
Learn Controls
Learn BizTalk
Learn SharePoint
Learn Mobile
Learn SQL
Learn SQL Reporting
Learn Windows Forms
Learn XML
Learn Crystal Reports
Learn FarPoint
Learn DevExpress
Examples
ASP.NET 2.0 Examples

ASP Tutorials
Learn ASP
Learn VBScript
Learn JScript
Learn SQL
Learn XML

Software Resources
Shopping Cart Ecommerce
Charts and Dashboards

Other Resources
Learn Java
Learn Oracle
Opinion / Editorial
Crystal Reports Alliance
WPF Resources
AJAX Resources
Silverlight Resources

Free Tools
Cache Manager
SimpleCMS

Reviews
Book Reviews
Product Reviews
Expert Advice

Books
ASP.NET Developer's Cookbook
Sample Chapters
Book Reviews

Community
Regular Expressions

Print Add To Favorites Email To Friend Rate This Article
Using LogParser 2.2 to Parse IIS Logs and Other Logs

page 4 of 13

by Sudeep G
Feedback

Average Rating:

Views (Total / Last 10 Days): 89305/ 131

Article Contents:

Scenario 2: Filtering

Now, let us say you want to trace requests from a specific client IP:

Listing 12

LogParser "SELECT * FROM ex080620.log WHERE c-ip='10.253.209.17'" -i:IISW3C -q:ON 
-o:datagrid

You can extend this further to trace requests from a specific client IP during a specific date range.

Listing 13

LogParser "SELECT * FROM ex080620.log WHERE date > '2008-06-19' AND date < 
'2008-07-22'" -i:IISW3C -q:ON -o:datagrid

View Entire Article

User Comments

No comments posted yet.

Product Spotlight

Community Advice: ASP | SQL | XML | Regular Expressions | Windows