Month: February 2016

ClearDB and Web Apps FAQ

If you are currently using ClearDB (MySQL ) service  with Azure App Service (Web Apps ) or planning to use these services , check out the FAQ  to understand how procurement of ClearDB which is third party service works with Web Apps for different types of Azure subscriptions.

Using Log parser 2.2 to parse IIS logs for Azure web apps

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows operating system such as the Event Log, the Registry, the file system, and Active Directory. This is how a IIS web server  log looks like which is hard to read when you want to gather information to either diagnose an issue or analyze the logs.

image

Parsing IIS logs

Log Parser tool allows you to analyze web server logs and event logs to provide you the snippet of information you are looking for .Download the tool and install the MSI package of the tool.

  • Usually the tool is installed on C:\Program Files\LogParser or  C:\Program Files (x86)\LogParser locally when running it from your client machine.
  • Another option is to upload LogParser.exe onto web app file server ( under D:\home) and run it using Azure web app KUDU debug console.

Here are some sample queries or command you can use to gather information about IPs , number of hits etc . To run these you need to execute LogParser.exe  with this command format

LogParser.exe -i:W3C Query -o:CSV Continue reading “Using Log parser 2.2 to parse IIS logs for Azure web apps”