Input Formats

Re: GZ Files?

joelangley — Fri, 05 Jun 2009 11:22:31 GMT

Thanks gluegood!

Re: GZ Files?

gluegood — Fri, 05 Jun 2009 10:57:27 GMT

Glad my code is helpful. Thanks joelangley for adding to my code.

Yours definately looks more extensive in the archive file types it supports - which is great for the community - I'll create a link on my site.

Gluegood

Re: GZ Files?

MatthewM — Thu, 04 Jun 2009 14:07:51 GMT

Thanks! I'll check out both sites.

Re: GZ Files?

joelangley — Thu, 04 Jun 2009 02:47:29 GMT

Blog post to solve this can be found here

Thanks to Gluegood who shared the original code with everyone a few months ago...his blog can be found here

Hope this helps you.

Re: GZ Files?

joelangley — Wed, 03 Jun 2009 20:15:20 GMT

gluegood posted something that decompressed files...but it had issues with .gz files (at least it did for me). I updated the code and got it to work, I'll post it on my blog tonight and will respond here when it's done.

Re: GZ Files?

ksingla — Wed, 03 Jun 2009 17:08:17 GMT

Logparser doesn't handle compressed files. You need to extract the files using some tool before feeding to logparser.

Thanks,
Kanwal

GZ Files?

MatthewM — Wed, 03 Jun 2009 14:49:00 GMT

I've read through the documentation and I can't find any indication of what I need to enter to get LogParser 2.2 to decompress a file in .GZ format prior to parsing. Is this possible or do I need to extract the files manually and then parse them?

The files themselves are in TEXTWORD format (.log) and when I run this command:

LogParser "SELECT Text, COUNT(*) FROM \\Filelocation\Filename.log.gz GROUP BY Text ORDER BY COUNT(*) DESC" -i:TEXTWORD

I get this in response:

Text COUNT(ALL *)
---- ------------
B    29
C    26
x    26
∩    24
0    24
→    24
Æ    23
O    23
R    23
☺    23
Press a key...
Text COUNT(ALL *)
---- ------------
}    22
]    21
┬    21
↔    21
╘    20
≈    20
▒    20
"    20
c    20
º    20
Press a key...

which looks to me like it's extracting the compressed characters.