More Easy: C:\>Tree /A > My_C_Tree.txt ;o)

Hello guys: Using logparser to generate a report so I can clean up my file server. For some reason logparser is giving me a year of 1969 on some files. running my query on a windows 2003 server against a share on windows 2000 if that helps. Thanks vizo

Thanks Daniel. Your reply got me thinking along a suitable track. I was averse to having a "token" file that is known to exist on the basis that one day there may be a need to include the given token file in the results but a variation on your suggestion works for me. Namely, to include within the "from...

Hrm. Only thing I can think of off the top of my head is to have a dummy file that is always there. Something like this worked for me: "C:\Program Files\Log Parser 2.2\LogParser.exe" -i:FS "SELECT path FROM C:\tmp\scores.txt, 'C:\tmp\*.xyz' WHERE Path <> 'C:\tmp\scores.txt'" Statistics: ----------- Elements...

When the input format is file system, if no files match the pattern, LogParser considers this an error. This is demonstable by the following: "C:\Program Files\Log Parser 2.2\LogParser.exe" -i:FS "SELECT path FROM '%WINDIR%\*.xyz'" Task aborted. Cannot open <from-entity>: Cannot find any file or...

by "documented" I mean I made a post where I gave an example of using the TPL output format to create a SQL query file that is then run by LP. It's in the General Discussion forums

[QUOTE User="LogParser User : justSteve"]Quote: I can't say as there is actually a drop dead easy way. Let me see if I understand exactly what you want. You want to run an LP query against the IIS log files to find out "active" pages, then you wa...[/QUOTE] Thanks for the quick reply...given this is...

I can't say as there is actually a drop dead easy way. Let me see if I understand exactly what you want. You want to run an LP query against the IIS log files to find out "active" pages, then you want to run another LP query against the FS input format to find files that are not in that "active" pages...

I'm inheriting a very old IIS box...it's been thru a number of different masters and has lots of files no longer in use intermixed with active files. I can produce a listing of pages served by IIS and files found via FS...I bet there's a drop dead easy way to do something like 'select name where [FSFiles...

My implementation is slightly different: select extract_token(path,add(1,strcnt('%CD%','\\')),'\\') as dir, sum(size) as sumsize from '%CD%\*' where Name not in ('.';'..') group by dir order by sumsize desc Note, if you save it as a file you have to call it like: logparser -i:fs file:getdiskspace.sql...