ZTree.com  | ZEN  | About...  

 Index   Back

[Tip] Checking path lengths with logparser   [Tip]

By: Ian Binnie   Homepage   Sydney  
Date: Jul 11,2013 at 17:59
In Response to: [Tip] Checking path lengths with logparser (Peter Shute)

> I am occasionally plagued by users creating files so deeply nested
> under directories with long names that the paths are too long for
> Windows' offline files to synchronise. It fails with the helpful message
> "The parameter is incorrect". (See
> http://www.ztw3.com/forum/forum_entry.php?id=92761 for a brief
> discussion)
>
> When I've requested that Ztree be given the ability to display/sort by
> total path length, it's been suggested that I use workarounds like
> Control+Insert or Control+Batch to calculate the lengths in Excel, etc.
>
> Here's a handy way to check path lengths quickly using MS's logparser
> command line SQL utility:
> LogParser.exe "SELECT top 10 add(strlen(path), strlen(name)) as
> pathlen, path, name FROM g:\userx\*.* order by pathlen desc" -i:fs
> -o:w3c
>
> That example will list the 10 longest full paths (including filename)
> of all files under g:\userx, showing the length, the dirpath and the
> filename.
>
> For those unfamiliar with it, logparser is a command line utility
> originally written by MS and released unofficially. It's intended for
> doing SQL queries on various kinds of log files, but includes the -i:fs
> switch to treat the file system as input.
>
> See
> http://strivinglife.com/words/post/Log-Parser-Plus-version-03-released.aspx
> and http://logparserplus.com/
>
> I'd still like this built into Ztree, but this is way faster than
> repeatedly pasting lists of paths into Excel, assuming .
>
> Just for interest, this is the longest path on my server, at 453
> characters:
> 453 g:\xxxx\My Documents\Dear hope things are
> going well and I just want to let everyone know that we will be running a
> bus to the xxxxxxxxx xxxxxxxxx conference
> to be held at xxxxxxxxxx Racecourse on 21st October.doc Dear
> hope things are going well and I just want to let everyone
> know that we will be running a bus to
> the xxxxxxxxx xxxxxxxxx conference to be held at xxxxxxxxxx
> Racecourse on 21st October.doc

I used to use a program CDCHECK; the primary purpose of this program was error recovery, but it also has an option to check files which could not be copied to CD/DVD because path exceeds 256 or name exceeds 64.

1,319 views      
Thread locked
 

Messages in this Thread

 
96,637 Postings in 12,231 Threads, 350 registered users, 72 users online (0 registered, 72 guests)
Index | Admin contact |   Forum Time: Mar 29, 2024 - 12:17 pm UTC  |  Hits:62,405,299  (20,085 Today )
RSS Feed