File Listing

[Guest]

I am trying to hunt down duplicate files that may exist in multiple
directories. I believe that Excel will be extremely valuable in doing this.

So I would LIKE to obtain a file listing from a Windows 2000 server that
lists all files in a format similar to this:
12/15/05 4:00 pm d:\dir1\file1.doc
12/15/05 4:01 pm d:\dir1\file2.doc
12/15/05 4:02 pm d:\dir1\file3.doc
12/15/05 4:00 pm d:\dir2\file1.doc
12/15/05 4:01 pm d:\dir2\file2.doc
12/15/05 4:02 pm d:\dir2\file3.doc

What I get when I do dir *.* /s is more like this:


Directory of d:\dir1

12/15/05 4:00 pm <dir> .
12/15/05 4:00 pm <dir> ..
12/15/05 4:00 pm file1.doc
12/15/05 4:01 pm file2.doc
12/15/05 4:02 pm file3.doc

Directory of d:\dir2
12/15/05 4:00 pm <dir> .
12/15/05 4:00 pm <dir> ..
12/15/05 4:00 pm file1.doc
12/15/05 4:01 pm file2.doc
12/15/05 4:02 pm file3.doc


I have tried tree and tree /a /f, which get me somewhat closer, but I still
would like to get a solid listing including file path on every single row, so
that I can manipulate easier in Excel.

Or does anyone have any other suggestions for this? Using the Windows 2000
"Search" utility is just not a good option . . . I have nearly 2TB of data in
thousands upon thousands of files and folders.

 

[Steve Parry]

Lady_MCSE fumbled, fiddled and fingered:

I am trying to hunt down duplicate files that may exist in multiple
directories. I believe that Excel will be extremely valuable in
doing this.

So I would LIKE to obtain a file listing from a Windows 2000 server
that lists all files in a format similar to this:
12/15/05 4:00 pm d:\dir1\file1.doc
12/15/05 4:01 pm d:\dir1\file2.doc
12/15/05 4:02 pm d:\dir1\file3.doc
12/15/05 4:00 pm d:\dir2\file1.doc
12/15/05 4:01 pm d:\dir2\file2.doc
12/15/05 4:02 pm d:\dir2\file3.doc

What I get when I do dir *.* /s is more like this:


Directory of d:\dir1

12/15/05 4:00 pm <dir> .
12/15/05 4:00 pm <dir> ..
12/15/05 4:00 pm file1.doc
12/15/05 4:01 pm file2.doc
12/15/05 4:02 pm file3.doc

Directory of d:\dir2
12/15/05 4:00 pm <dir> .
12/15/05 4:00 pm <dir> ..
12/15/05 4:00 pm file1.doc
12/15/05 4:01 pm file2.doc
12/15/05 4:02 pm file3.doc


I have tried tree and tree /a /f, which get me somewhat closer, but I
still would like to get a solid listing including file path on every
single row, so that I can manipulate easier in Excel.

Or does anyone have any other suggestions for this? Using the
Windows 2000 "Search" utility is just not a good option . . . I have
nearly 2TB of data in thousands upon thousands of files and folders.

What about

ATTRIB /S /D > c:\filename.txt

Any help?


--
Steve Parry BA (Hons) MCP


http://www.gwynfryn.co.uk

http://www.petitiononline.com/X30WM5/petition.html

 

[Guest]

Hmm, good idea . . . I hadn't thought of that one. That's better than what
I've been getting, but I'd still like date and time stamp so I can determine
if two files are exactly the same.

That's the users' argument - "but File1.doc and file1.doc are different,
they're in two different folders!" but if I can show them that both files
were modified on the exact same date at the exact same time and the exact
same file size, I will have a little more proof.

Silly marketing department, macs are for kids.

 

[John John]

Hmmm. I'm not so sure that I would consider files with the same name,
same size, same timestamp as duplicates! While it can be a good
indication of duplicates it cannot be a trusted method for finding true
duplicates. The only way to ensure that the files are real duplicates
is to do comparison of the contents. Maybe this can make your job
easier. http://dff.nazrashid.com/index.php I use it and find it to be
reliable and reasonably fast at processing large number of files.

John