Analyzing IIS server logs

Wednesday

Jun102009

Wednesday, June 10, 2009 at 1:20PM

Today I had to analyze a Microsoft's IIS web server log, trying to find some search engine referrers. I received log files from over the last 5 years and I was asked to filter out the keywords entered by customers for marketing purposes. These files aren't stable Apache logs at all! Now and then, the number of columns differs order changes so a simple AWK or GREP could not be used. That's weird! Lucky as I am, there are some headers in each log file, but should I write some scripts for ordering these info? No!...

Microsoft presents a tool for a analyzing the IIS log files and this tool is rather good. It accepts queries in SQL format! 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. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart. The world is your database with Log Parser.

Some examples (more at source):

• Top 20 URLs Hit
logparser "SELECT TOP 20 cs-uri-stem, COUNT(*) AS Hits INTO Analysis.csv from ex061023.log group by cs-uri-stem order by Hits DESC"

• Referrer Host Names directing traffic to this server with count of pages referred (summary)
logparser "SELECT ReferringHost, count(*) AS TotalReferrals, Min(cs(Referer)) AS ExampleRefererURL USING CASE EXTRACT_TOKEN(cs(Referer),2, '/') WHEN null THEN 'NoReferer' ELSE EXTRACT_TOKEN(cs(Referer),2, '/') END as ReferringHost into IISLOG_ANALYSIS_REFERER_HOSTS.CSV FROM ex061023.log group by ReferringHost order by count(*) DESC"

Captain Rtfb | in

Tips and Tricks

7 Comments |

Permalink | |

Print Article |

Email Article

View Printer Friendly Version

Email Article to Friend

Reader Comments (7)

This is a good article,thank you for your share,I like it very much.Our products are superior in quality and moderate in price and are sure to be saleable in your market,by virtue of this superior quality, this product is often sold out in many areas. This new product is really much better than the previous one. You have to try it to believe it.Replica Handbags Wholesale|

September 16, 2010 |

Replica Handbags Wholesale

October 30, 2010 |

christian louboutin

Original artwork rembrandt paintings is artwork that has been created specifically for renoir paintings you. You may have seen pieces by the artist that abstract oil paintings had a similar look and feel or were of a similar subject matter, matisse paintings but an original piece is one that you have goya paintings commissioned. The benefit of asking a contemporary modern oil paintings painter to create an original piece for you is oil painting from photo that you can tell them what wholesale oil painting you have in mind, you can oil paintings wholesale ask for specific colors flower oil painting in a specific size, and have a piece created that is still life oil paintings exactly what you were looking for, without having seascape oil paintings to spend hours and hours searching for just the van gogh oil paintings right piece, to no avail. iphone cases
iphone covers
iphone 3gs cases
iphone 3g cases
iphone 4 cases
white iphone 4
iphone 4 white
white iphone
white iphone 4 available

November 30, 2010 |

artrepro

ugg boots
cheap ugg boots
discount ugg boots
wholesale ugg boots
ugg classic boots
ugg bailey button
ugg cardy boots
kids ugg boots
ugg slipper
ugg 1886
ugg 5163
ultra short ugg boots
ultra tall ugg boots
ugg 5273
ugg 5359
classic tall ugg boots
classic short ugg boots
paisley short ugg boots
mini ugg boots
ugg 5899
ugg 5803
ugg 5819
argyle knit ugg boots
kids bailey button ugg
ugg 5304
ugg 5616
ugg 5822
Adirondacks II UGG Boots
Highkoo UGG Boots
Tan Payton UGG Boots
Knightsbridge UGG Boots
cheap uggs
uggs outlet
cheap ugg boots
discount uggs
kids ugg boots
ugg boots on sale
ugg store
uggs boots cheap
buy uggs boots
ugg classic short
ugg mini
ugg ultra short
ugg classic tall
ugg ultra tall
ugg ultimate
ugg nightfall
ugg sundance
ugg delaine
ugg broome
ugg elsey
ugg highkoo
ugg classic cardy
ugg stripe cable
ugg classic argyle
ugg bailey button
ugg bailey boots
ugg bailey button triplet
ugg bailey button fancy
ugg kids short
kids bailey button
ugg slippers
ugg outlet
discount ugg boots
ugg short boots
ugg tall boots
ugg cardy boots

December 13, 2010 |

cheap ugg boots

Top Selling Bridesmaid Dresses are very popular, so you should buy some Top Selling Bridesmaid Dresses,Junior Bridesmaid Dresses are also very popular, so you should buy someJunior Bridesmaid Dresses,Short Bridesmaid Dresses are also very popular, so you should buy someShort Bridesmaid Dresses,Long Bridesmaid Dresses are also very popular, so you should buy someLong Bridesmaid Dresses,Simple Bridesmaid Dresses are also very popular, so you should buy someSimple Bridesmaid Dresses,Evening Dresses 2011 are also very popular, so you should buy someEvening Dresses 2011,Sexy Evening Dresses are also very popular, so you should buy someSexy Evening Dresses,Elegant Evening Dresses are also very popular, so you should buy someElegant Evening Dresses,Short Evening Dresses are also very popular, so you should buy someShort Evening Dresses,Long Evening Dresses are also very popular, so you should buy someLong Evening Dresses,Plus Size Evening Dresses are also very popular, so you should buy somePlus Size Evening Dresses.Faviana a short Carolina Bang dress.Full Katherine Heigl dress are also fantastic. Allure is essential element of JESSICA BIEL DRESS too.
Dresses for semi formal occasions could be a bit less textured compared to formal functions. It doesn’t need to be full length but short plus size wedding dresses will also do. Faviana Style: 6216 is a short Carolina Bang dress. It is stretch satin dress with back closure, sweetheart neckline and thick straps.Summer Wedding Dresses is made in black, red, teal, and white. Dressy pants and overcoats are acceptable. Full Katherine Heigl dress are also fantastic. Allure is essential element of JESSICA BIEL DRESS too. Material choice for dresses must be dressy like silk, velvet, cashmere, brocade, beach wedding dresses.I really loved this post. You write about this topic very well. There are many prized moments in life, why not buy a Hot Prom Dresses. When looking back on photos of your loved one wearing a Simple Wedding Dresses, it will put a smile on your face.
Wedding Guide|Wedding Veils|Wedding Tiara|Wedding Petticoat|Wedding Jewelry|Wedding Gloves|Wedding Accessories|Homecoming Dresses|Evening Dresses|Cocktail Dresses|Ball Gown|Formal Dresses|Girls Princess Dresses|Party Girls Dresses|Holiday Girls Dresses|Flower Girl Dresses|Simple Bridesmaid Dresses|Long Bridesmaid Dresses|Short Bridesmaid Dresses|Junior Bridesmaid Dresses|Bridesmaid Dresses|Sexy Wedding Dresses|Elegant Wedding Dresses|Chic/Modern Wedding Dresses|Classic Wedding Dresses|Simple Wedding Dresses|Reception Wedding Dresses|Beach Wedding Dresses|Wedding Dresses|Bridal Gowns|formal-dresses-for-winter-2010,how-to-buy-formal-dresses,formal-dress-for-women-2011.

January 6, 2011 |

plus size wedding dresses

As for Word 2010, Microsoft Office I really like the ribbon effect Microsoft Office 2007. The only really annoying thing so far is Micro office 2010 that once a document is closed, it doesn't show up on the "Recent Documents" list if it is download Office 2010 saved in the temp directory (for example). So, 2010 office if you forget to save your doc to the Office 2007 right place, it may be hard to find. For me, being on the set of the Martha Stewart television show Office Microsoft 2010 was a treat. It was the Office 2010 download second time, actually, because back in October Anduin showcased Office Microsoft Microsoft OneNote on the air for how it was office 2010 professional helping her keep track of everything from her daughter's school information to her holiday gift list to her complete set of Thanksgiving plans. This was simple to install, early loaded onto my new Windows 7 program. Office 2010 I had no problem MS office 2007 linking over old files from my MS office 2010 old computer. Old file information was easy absorbed by the 'New' versions of the various office products and Microsoft outlook 2010 in just a few minutes all my Office 2007 key old data was reasonable so I had very minimal down time. Last week, the Martha Stewart show featured Microsoft office professional 2010 Word in a television segment about office 2010 pro how to make personal holiday cards quickly and easily. As the product guy responsible for most of the Office Microsoft outlook apps, of course I was Office 2007 download tickled by the fact that Office 2010 Microsoft Word was going to be on TV. Word doesn't get much stage time, you understand. She's definitely the behind-the-scenes kind of girl; much like Anduin Havens, who is the art director for the Microsoft Office 2010 Martha Stewart show download Office 2007. Anduin has got to be one of the 2010 Office Microsoft most creative people I've ever met. She's brilliant, she's won an Emmy for her work on creating the Outlook 2010 set of the show, and she made Office 2010 key these beautiful holiday cards office 2010 home in Word, which were featured on the air.

April 13, 2011 |

Office 2010

September 18, 2011 |

ddddddddd

Post a New Comment

Enter your information below to add a new comment.

My response is on my own website »

Author:

Author Email (optional):

Author URL (optional):

Post:

↓ | ↑

Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>