scan for file types like mp3 and jpg

[steppingstones]

I need to scan a file server for certain file types and import the results into a spreadsheet. I had hoped I could do it with the DIR command but the output would take too much work to format it correctly. Any ideas to what seems to be such a simple problem.
Thanks,
Chris

 

[mrdenny]

Use the DIR command but strip out the headers.

dir /B /S *.mp3

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[karmic]

dir /B /S *.mp3 >c:\filename.txt

the > will redirect the results to a text file named filename.txt (or whatever you want to call it) on the root of C:.

You won't see the filenames it finds, just wait for it to finish and you can import to excel...

~ K.I.S.S - Don't make it any more complex than it has to be ~

 

[steppingstones]

Thanks for the replies. I left out part of the problem. Not only do I need the complete path, but also need the size of the files. Running the search command in Windows shows me what I need, except I cannot export the list to Excel.
Thanks again for your replies.

 

[asmith1972]

You can get a small usility called Network File Locator that can do this, I think you can even schedule it run every month or so:

http://www.purenetworking.net/Products/NetworkFileLocator/NetworkFileLocator.htm