ansaurus

Question

How do I use LogParser to find out the LENGTH of a field in an IIS Log?

Answer 1

+33 A:

Well, looks like I answered my own question.

LogParser.exe -i:IISW3C 
"SELECT COUNT(cs(User-Agent)) AS Client 
FROM *.log WHERE STRLEN(cs(User-Agent)) > 100"

Scott Hanselman 2008-09-17 07:47:30

Can't vote for me! EPIC FAIL! ;)

Scott Hanselman 2008-09-17 07:47:47

LOL! I'll vote for you Scott! :D

Rob Cooper 2008-09-17 07:57:35

Thanks! Now the REAL question is, WHO accepts MY answer?

Scott Hanselman 2008-09-17 07:58:19

No one can, you just get the +points for the upvotes, you can close the question (not allowing more answers), but that freezes voting..

Rob Cooper 2008-09-17 07:59:32

That's lame. It'll never turn green.Hey, how did you know I added comment? Is CTRL-F5 the way "notifications" work in this world?

Scott Hanselman 2008-09-17 08:01:54

Yup, refresh is the key :) I don't know if we will ever get a good "subscribe" feature :( This post has inspired me for more content for my next SO post though. Thanks :)

Rob Cooper 2008-09-17 08:04:35

Heh. I think I'm just going to hang out inside this tiny comment box. This is my new HanselIRC.

Scott Hanselman 2008-09-17 08:13:20

LOL! Do you not find it annoying having to keep clicking "show" though? Although it is pretty cool seeing your votes go up..

Rob Cooper 2008-09-17 08:17:54

I dunno...the REAL test for SO will be if and when they start dominating all Google results. I also am concerned about their database fragmentation, and I predict we'll see REAL problems with that and SQL Page size soon.

Scott Hanselman 2008-09-17 08:25:36

Agreed, only time will tell I guess. IMO there is still also tons of work to be done on fundamental parts of the site.. Especially with regards to moderation.. But, I am just a humble user :)

Rob Cooper 2008-09-17 08:28:15

hehe... this is another way to use SO... Public IM! ;)

Adhip Gupta 2008-09-17 08:51:32

Yes! Although, this refresh this is troublesome. ;) Also, the font is VERY small on Google Crome.

Scott Hanselman 2008-09-17 08:52:18

Oh you need to change your default font, its under the spanner somewhere :D SO, you think with the chat we can make Mr Hanselman's first question on SO a "Hot" topic? :D Hell if we talk long enough you will get a nice badge :)

Rob Cooper 2008-09-17 08:53:29

http://stackoverflow.com/badges/28/famous-question - There it is people, thats what we want to win for Scott :D

Rob Cooper 2008-09-17 08:54:03

Apparently I'd just got a COMMENTATOR badge for talking to myself.

Scott Hanselman 2008-09-17 08:56:41

Oh crap yeah, I dont think you would get the famous question goldie (currently awarded to someone IMO should not have it) because you made the question "community editable".. Silly Scott! Still, talking to yourself has never been so rewarding right? :D

Rob Cooper 2008-09-17 09:00:01

Scott, this is a cheap shot to get rep ;-) As if you don't have enough rep as is? :P

Jonas Follesø 2008-09-17 09:13:39

What are you talking about Jonas?! I never even knew who Scott was until I saw this question! :p :D

Rob Cooper 2008-09-17 09:19:35

This comment section could end up being a good stress-test. How many comments before the "Show Comments" call dies?

Mark Biek 2008-09-17 14:06:53

Do I want REP? What can I buy with REP? ;)

Scott Hanselman 2008-09-17 21:25:19

ansaurus

tags:

views:

answers:

How do I use LogParser to find out the LENGTH of a field in an IIS Log?

related questions