If you troubleshoot day in and day out, you will deal with an amazing amount of data. Because, to find out the cause and get to the bottom of the issue, we look into lot of places. For example: IIS Logs (If we are troubleshooting issues related to websites hosted in IIS), Windows event logs, Network traces, Custom logs in various formats, Process monitor, Performance monitor, ETW traces, Active directory objects, Registry and what not. In this series of videos, we will discuss about a simple but a powerful tool called LogParser which will help us analyze these log files with tremendous amount of data to troubleshoot variety of issues like slow performance, DOS attacks, session loss etc.
These videos will help anyone who does troubleshooting be it a developer, system admin or end user to effectively analyze various log files.
Queries used in this session
LogParser -i:IISW3C "SELECT DISTINCT cs(cookie),cs-username,count(*) FROM C:UsersjawsDesktopSession3.log WHERE cs(cookie) IS NOT NULL AND cs-username IS NOT NULL GROUP BY cs-username,cs(cookie)" -o:DataGrid