In Reply to: RE: Nope!, Never had that problem ....................... posted by LtMandella on September 29, 2020 at 16:34:11:
First step would need to be an inventory solution.
Agreed. But ten small-to-medium sized drives is surely manageable. The 8TB one might be a little more interesting. I suppose I'm assuming you mostly have a reasonably consistent naming scheme.
1. Instead of worrying about "Index DeviceID Signature Models" and the like, why not just write a number on each HDD with a felt pen?
2. As Windows doesn't (AFAIK) give you a way of readily listing the contents of a folder, I use a batch file some kind chap posted somewhere years ago. It works well - see below for text. Call it, say, "PrintDir" and put a shortcut to it in your "Send To" folder. That would allow you to fire up each HDD in turn, open it in Explorer and right-click to run the batch file and so obtain a text-file listing of the disk's contents.
3. Copy the text into Excel, have the program quasi-automagically add the felt-penned drive number in the next column and save. You should end up with an Excel list for each drive. (Ditto-ish for sub-folders if applicable.)
4. Merge the separate drive-by-drive lists into one or more "master" spreadsheets and use Data > Sort to list files alphabetically even though they're on separate drives.
OK, it won't be quite as straightforward in practice but I know the idea works in general because I've used it before.
HTH
Dave
++++
"Known Good" batch file:
@echo off
dir %1 /-p /b /d /o:gn > "%temp%\Listing1"
start /w notepad "%temp%\Listing1"
del "%temp%\Listing1"
exit
This post is made possible by the generous support of people like you and our sponsors:
Follow Ups
- RE: Nope!, Never had that problem ....................... - Ryelands 10:20:59 09/30/20 (1)
- RE: Nope!, Never had that problem ....................... - LtMandella 10:37:19 09/30/20 (0)