Excel PivotTable report for the IIS Log Analyzer Tool

Source: Internet
Author: User

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

There are a lot of tools for analyzing IIS on the Internet, but I didn't meet my requirements, and generally I can only query the number of spiders crawling in the IIS log. Here is a relatively simple and very practical way, through some simple Excel formula to make a series of data, such as time interval, crawling page, return status code, URL parameters, spider type, spider IP, etc., through the above data can be used to troubleshoot the site, correction. You must first have your own server or be able to view the permissions of the IIS log, download the IIS log files from space to the local server via FTP to get IIS logs: Open IIS, click to query website > right > Properties > Site tab > Properties > You can see that some space services will place the log files in the root directory of the Web site, as shown in the figure if space. If not, you can ask the service provider.

  

Then find the appropriate folder based on the path and then you can see that there are a lot of. log files in the folder, which are then downloaded locally via FTP.

  

If the file is too large to operate may not be, you can use UltraEdit open, screen the data you want to get (specific download a study). File is not very large you can use Notepad to open and copy to Excel.

  

Then delete the first 4 lines, select Column A, click Excel data > Break down > Split symbols

  

  

Next > Other > Input blanks > Next > Complete. This completes the first step.

  

Then select the A1 column > right > Insert and delete the C,d,e,i column. Enter the first line: date, time, Web page, parameter, port, IP, spider, Status code another description of the parameters, this is the dynamic page face question mark (?) The back part. Http://www.huiwang.org/jiaju/chufang/5309_3.html the parameter value after this path is 3, then the combination is really the URL is http://www.huiwang.org/jiaju/ Chufang/5309_3.html?3 so that the spider can also be able to identify parameters, and some sites put ads often with the following parameters on the statistics, but after fetching parameters will be removed. So try not to use the URL of this class on the content page.

  

Select G > Data > Filter > Click g Column Arrow > Text filter > contains

  

Enter Baidupider Click OK. You can see all the data Baidu spider access to such words roughly the data has been presented, if you look at Google in the filter when the input Googlebot can be. Then make a simple PivotTable report for easy analysis. One order: Insert > Pivot table > Pivot table > OK on the right click on the order of the page, spider, Time. Then click on the small triangle behind the spider

  

Click Tab filter > Include > Input baidupider. Can filter out the end of the page to see the spider crawl time detailed data, of course, can be filtered according to other combinations of various types of data, will not be demonstrated.

  

Luigi ' s blog original, reprint please specify http://www.itemseo.com/432.html thank you

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.