Advertisements

 

Recent comments
« Fun with iPhone push | Main | DD-WRT on my old Asus WL-500G »
Wednesday
Jun102009

Analyzing IIS server logs

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"

PrintView Printer Friendly Version

EmailEmail 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 | Unregistered CommenterReplica Handbags Wholesale

It is said that one pair of shoes name is Christian Louboutin,deeply lady's welcome, wearing Tiffany Jewelry, put on the Tiffany luxuriant Moncler, is every woman love most, and Vibram Five Fingers and NFL Jerseys, is also a lot of people like.
Christian Louboutin Knockoffs,Christian Louboutin Wedding Shoes,Christian Louboutin Boots,Christian Louboutin Sandals,Christian Louboutin Wedges,Christian Louboutin Platform,Christian Louboutin Sneakers,
Christian Louboutin Nappa Bootie,Christian Louboutin Ankle Boots,Christian Louboutin Leopard Boots,christian louboutin leopard,christian louboutin python pumps,christian louboutin black pumps,christian louboutin platform pump,Christian Louboutin Peep Toe,Christian Louboutin Declic Pumps,christian louboutin very prive pumps,Christian Louboutin Slingbacks,Christian Louboutin Cathay,Christian Louboutin High Heels,Christian Louboutin Pigalle,Christian Louboutin Mary Janes,Christian Louboutin Wedding Shoes,Christian Louboutin Declic Leather Pumps,Christian Louboutin Lace Up Boots,Christian Louboutin Robot,Christian Louboutin Peep Toe Boots,Christian Louboutin over the knee boots,christian louboutin babel boots,Christian Louboutin Bandage Boots,Christian Louboutin Bouquet Platform,Christian Louboutin Dillian Pumps,christian louboutin macarena,red sole shoes,Christian Louboutin Flats,Christian Louboutin Double Platform Sandal,Christian Louboutin Evening,christian louboutin calypso pumps,christian louboutin d'orsay,Christian Louboutin Alta Nodo,christian louboutin petal pumps,christian louboutin petal crepe satin sandal,replica christian louboutin shoes,Christian Louboutin Platform Pumps,Christian Louboutin Espadrille Wedge,Christian Louboutin Jeweled Pumps,christian louboutin cutout pump,Christian Louboutin Cutout Bootie,christian louboutin glitter pump,christian louboutin circus boots,christian louboutin sample sale,ED Hardy ED Hardy,Nike Shoes Nike Shoes,Abercrombie and Fitch Abercrombie and Fitch,Gift Ideas Gift Ideas,Tiffany Jewelry Tiffany Jewelry,Ball Bearing Ball Bearing,Christian Louboutin Christian Louboutin Discount,UGG Boots UGG Boots,EMU Boots EMU Boots,Louis Vuitton Handbags Louis Vuitton Handbags,Christian Audigier Christian Audigier.

October 30, 2010 | Unregistered Commenterchristian 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 | Unregistered Commenterartrepro

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 | Unregistered Commenterplus 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 | Unregistered CommenterOffice 2010

It’s really a nice and helpful piece of information.!!~!~!~!~!~!
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie uk
Abercrombie Fitch uk
Abercrombie & Fitch uk
Abercrombie and Fitch uk
Abercrombie outlet
Abercrombie online
Abercrcrombie store
Abercrombie shop
Abercrombie
I’m glad that you shared this helpful info with us. Please keep us informed like this. Thanks for sharing.
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie uk
Abercrombie Fitch uk
Abercrombie & Fitch uk
Abercrombie and Fitch uk
Abercrombie outlet
Abercrombie online
Abercrcrombie store
Abercrombie shop
Abercrombie
What a fun pattern! It's great to hear from you and see what you've sent up to.
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie Milano
Abercrombie Fitch Milano
Abercrombie & Fitch Milano
Abercrombie and Fitch Milano
Abercrombie Italia
Abercrombie Fitch Italia
Abercrombie and Fitch Italia
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie Milano
Abercrombie Fitch Milano
Abercrombie & Fitch Milano
Abercrombie and Fitch Milano
Abercrombie Italia
Abercrombie Fitch Italia
Abercrombie and Fitch Italia
Abercrombie
Abercrombie & Fitch
All of the projects look great! You make it so simple to this. Thanks
Abercrombie and Fitch
Abercrombie Deutschland
Abercrombie Fitch Deutschland
Abercrombie & Fitch Deutschland
Abercrombie and Fitch Deutschland
Hollister Deutschland
Hollister Frankfurt
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie Deutschland
Abercrombie Fitch Deutschland
Abercrombie & Fitch Deutschland
Abercrombie and Fitch Deutschland
Hollister Deutschland
Hollister Frankfurt
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie London
Abercrombie Fitch London
Abercrombie & Fitch London
Abercrombie and Fitch London
Abercrombie outlet
Abercrombie online
Abercrcrombie hoodies
Abercrombie men
Abercrombie women
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie London
Abercrombie Fitch London
Abercrombie & Fitch London
Abercrombie and Fitch London
Abercrombie outlet
Abercrombie online
Abercrcrombie hoodies
I am often to blogging and i really appreciate your content.
Abercrombie men
Abercrombie women
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie Paris
Abercrombie Fitch Paris
Abercrombie & Fitch Paris
Abercrombie and Fitch Paris
Abercrombie France
Abercrombie Fitch France
Abercrombie and Fitch France
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie Paris
Abercrombie Fitch Paris
Abercrombie & Fitch Paris
Abercrombie and Fitch Paris
Abercrombie France
Abercrombie Fitch France
Abercrombie and Fitch France
Hollister
Hollister UK
Hollister London
Hollister outlet
Hollister online
Hollister clothing
Hollister clothes
Hollister sale
Hollister
Hollister UK
Hollister London
Hollister outlet
Hollister online
Hollister clothing
Hollister clothes
Hollister sale
Hollister
Hollister UK
Hollister London
Hollister outlet
Hollister online
Hollister clothing
Hollister clothes
Hollister sale
Hollister
Hollister outlet
Hollister online
Hollister clothing
Hollister clothes
Hollister sale
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie Deutschland
Abercrombie Fitch Deutschland
Abercrombie & Fitch Deutschland
Abercrombie and Fitch Deutschland
Hollister Deutschland
Hollister Frankfurt
tiffany uk
tiffany London
tiffany outlet
tiffany online
The article has really peaks my interest. I am going to bookmark your site and keep checking for new information.
tiffany jewelry
tiffany co
Hollister
Hollister UK
Hollister London
Hollister outlet
Hollister online
Hollister clothing
Hollister clothes
Hollister sale
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie London
Abercrombie Fitch London
Abercrombie & Fitch London
Abercrombie and Fitch London
Abercrombie outlet
Abercrombie online
Abercrcrombie hoodies
Abercrombie men
Abercrombie women
Abercrombie
Abercrombie & Fitch
Abercrombie and Fitch
Abercrombie uk
Abercrombie Fitch uk
Abercrombie & Fitch uk
Abercrombie and Fitch uk
Abercrombie outlet
Abercrombie online
Abercrcrombie store
Abercrombie shop
jack wills
jack wills outlet
jack wills online
jack wills clothing
jack wills uk
jack wills clearance
jack wills sale
A unique discussion merits a comment. I LOVE YOU

September 18, 2011 | Unregistered Commenterddddddddd

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
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>