Creating a list of file paths
-
My company is getting ready to revamp our intranet and have a desire to clean out our servers of all files, documents and applications that are not being used. I've already loaded all the IIS log files into a SQL table for the past 15 months and am looking for a way to compile a complete list of all file paths ("C:\apps\test\default.asp") in the form of a text file that I can then load into a seperate table and do some cross checking. Any hints/solutions are greatly appreciated.
An American football fan - Go Seahawks! Lil Turtle
-
My company is getting ready to revamp our intranet and have a desire to clean out our servers of all files, documents and applications that are not being used. I've already loaded all the IIS log files into a SQL table for the past 15 months and am looking for a way to compile a complete list of all file paths ("C:\apps\test\default.asp") in the form of a text file that I can then load into a seperate table and do some cross checking. Any hints/solutions are greatly appreciated.
An American football fan - Go Seahawks! Lil Turtle
As you'll likely be needing code of some sort, you might have a bit more luck with this here.
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
-
My company is getting ready to revamp our intranet and have a desire to clean out our servers of all files, documents and applications that are not being used. I've already loaded all the IIS log files into a SQL table for the past 15 months and am looking for a way to compile a complete list of all file paths ("C:\apps\test\default.asp") in the form of a text file that I can then load into a seperate table and do some cross checking. Any hints/solutions are greatly appreciated.
An American football fan - Go Seahawks! Lil Turtle
Try this:
dir C:\*.* /s > AllFilesAndFolders.txt
Farhan Noor Qureshi
-
Try this:
dir C:\*.* /s > AllFilesAndFolders.txt
Farhan Noor Qureshi
:omg: Large file.
God Bless, Jason
I am not perfect but I try to be better than those before me. So those who come after me will be better than I am. -
:omg: Large file.
God Bless, Jason
I am not perfect but I try to be better than those before me. So those who come after me will be better than I am.That was meant for reference only.
Farhan Noor Qureshi
-
Try this:
dir C:\*.* /s > AllFilesAndFolders.txt
Farhan Noor Qureshi
And add a
/Btoo -
As you'll likely be needing code of some sort, you might have a bit more luck with this here.
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
Thanks for the suggestion:), but what I'm trying to do is get a text list of the directory paths first then I can worry about loading the list into the database. i.e. "C:\ File Folder" "C:\apps\TrackIt\default.aspx 12 KB ASP.NET Server Page" "C:\apps\TrackIt\default.aspx.cs 15 KB Visual C# Source File" . . . . "C:\docs\HR\Employee Policies.doc 124 KB Microsoft Word Document" The actual path is what I'd like to check the log files against. I appreciate the help, though.
An American football fan - Go Seahawks! Lil Turtle
-
My company is getting ready to revamp our intranet and have a desire to clean out our servers of all files, documents and applications that are not being used. I've already loaded all the IIS log files into a SQL table for the past 15 months and am looking for a way to compile a complete list of all file paths ("C:\apps\test\default.asp") in the form of a text file that I can then load into a seperate table and do some cross checking. Any hints/solutions are greatly appreciated.
An American football fan - Go Seahawks! Lil Turtle
Simple solution:
- Delete everything.
- Restore those items people complain about.
After a month or two, things should have stabilized to only those items that are actually in use. (Sorry; I'm wasting time twiddling my thumbs engaging in offline research during the last hour of the day before vacation, so my facetious quotient is off the scale)
Software Zen:
delete this; -
And add a
/BtooThanks for the suggestion.
/Bcan be very handy. -- modified at 15:53 Thursday 27th September, 2007
Farhan Noor Qureshi
-
My company is getting ready to revamp our intranet and have a desire to clean out our servers of all files, documents and applications that are not being used. I've already loaded all the IIS log files into a SQL table for the past 15 months and am looking for a way to compile a complete list of all file paths ("C:\apps\test\default.asp") in the form of a text file that I can then load into a seperate table and do some cross checking. Any hints/solutions are greatly appreciated.
An American football fan - Go Seahawks! Lil Turtle
Farhan almost nailed it
dir basepath /b /s >files.txt
gives all file and folder names recursively, one full file or folder path per line. This is what I found easiest to work with. Use
dir basepath /b /s /A:D >files.txt
to list only directories and
dir basepath /b /s /A:D- >files.txt
to list only files
We are a big screwed up dysfunctional psychotic happy family - some more screwed up, others more happy, but everybody's psychotic joint venture definition of CP
My first real C# project | Linkify!|FoldWithUs! | sighist -
My company is getting ready to revamp our intranet and have a desire to clean out our servers of all files, documents and applications that are not being used. I've already loaded all the IIS log files into a SQL table for the past 15 months and am looking for a way to compile a complete list of all file paths ("C:\apps\test\default.asp") in the form of a text file that I can then load into a seperate table and do some cross checking. Any hints/solutions are greatly appreciated.
An American football fan - Go Seahawks! Lil Turtle
I've found the answer! There is a app called DDFileCatcher that will scan an entire drive and return all the file paths.:-D
An American football fan - Go Seahawks! Lil Turtle
-
Farhan almost nailed it
dir basepath /b /s >files.txt
gives all file and folder names recursively, one full file or folder path per line. This is what I found easiest to work with. Use
dir basepath /b /s /A:D >files.txt
to list only directories and
dir basepath /b /s /A:D- >files.txt
to list only files
We are a big screwed up dysfunctional psychotic happy family - some more screwed up, others more happy, but everybody's psychotic joint venture definition of CP
My first real C# project | Linkify!|FoldWithUs! | sighistThanks, I'll save this in my snippet reference sheet.:)
An American football fan - Go Seahawks! Lil Turtle
-
Simple solution:
- Delete everything.
- Restore those items people complain about.
After a month or two, things should have stabilized to only those items that are actually in use. (Sorry; I'm wasting time twiddling my thumbs engaging in offline research during the last hour of the day before vacation, so my facetious quotient is off the scale)
Software Zen:
delete this;:laugh: Nice!!! If it wasn't the 'suggestion' of the CEO I'd probably consider it.
An American football fan - Go Seahawks! Lil Turtle
-
I've found the answer! There is a app called DDFileCatcher that will scan an entire drive and return all the file paths.:-D
An American football fan - Go Seahawks! Lil Turtle
Seriously, what peterchen and Farhan suggest works. And it is free plus you already have it. dir works. :)
regards, Paul Watson Ireland & South Africa
Andy Brummer wrote:
Watson's law: As an online discussion of cars grows longer, the probability of a comparison involving the Bugatti Veyron approaches one.
-
My company is getting ready to revamp our intranet and have a desire to clean out our servers of all files, documents and applications that are not being used. I've already loaded all the IIS log files into a SQL table for the past 15 months and am looking for a way to compile a complete list of all file paths ("C:\apps\test\default.asp") in the form of a text file that I can then load into a seperate table and do some cross checking. Any hints/solutions are greatly appreciated.
An American football fan - Go Seahawks! Lil Turtle
At the risk of being a pain... I wrote an application which will do this. I'm not just trying to flog my software as I wrote it to do the sort of thing you are after. Visit my website at wwww.tebofile.com where you can download a trial version of tebofile. The trial is good for 31 days. This allows you to scan a path(including network paths) and view output the results to a csv file. Let me know if it does the job
You always pass failure on the way to success.
-
At the risk of being a pain... I wrote an application which will do this. I'm not just trying to flog my software as I wrote it to do the sort of thing you are after. Visit my website at wwww.tebofile.com where you can download a trial version of tebofile. The trial is good for 31 days. This allows you to scan a path(including network paths) and view output the results to a csv file. Let me know if it does the job
You always pass failure on the way to success.
Thanks, I'll give it a go.
An American football fan - Go Seahawks! Lil Turtle