[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

Searching for old files - by last modified

I have a lot of data. I want to move data that has not been accessed in the last 3years. What tool can I use to scan and report on data that has not been touched in a long time. I would love the ability to forgo folder dates and just retrieve the information on the files themseleves?
0
sparkis
Asked:
sparkis
  • 5
  • 3
  • 2
1 Solution
 
Bradley HaynesCommented:
Use the Where.exe cmd :
http://articles.techrepublic.com.com/5100-10878_11-6145407.html
in a .bat file and pipe it to an "Archive Folder" based on dates via a script using WSH or VBS.
0
 
Bradley HaynesCommented:
This may help with the scripting.
http://www.aspfree.com/c/a/Windows-Scripting/Age-Based-File-Deletion-in-WSH/
When you say " I would love the ability to forgo folder dates and just retrieve the information on the files themseleves"; are you referring to the data in the files?
0
 
sparkisAuthor Commented:
Thanks B. I am refering to the dates on the files within the folders.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Bradley HaynesCommented:
I would use the Where.exe tool. Run this from the cmd.exe line. Do run-->cmd enter on the command line type in Where /? to get examples and use Google for examples on using the tool recursively (to search folder and subfolders etc).
Using the Date Created or Last Modified will return file for certain dates. You can also specify a date range...
0
 
MightySWCommented:
Hi, why don't you just use search and sort by date?

Is this something that you want to use on a regular basis?
0
 
sparkisAuthor Commented:
where /r G:\ *.*

This would return all files on the G: drive. How can I say all files modified before 4/31/2004 - can you do this?
0
 
Bradley HaynesCommented:
/T: Shows you the size of each file as well as the most recent modification date; particularly useful if you find multiple files with the same name. Example:
where /T /R c:\ *.bat searches the entire C: drive for every file that has a .BAT extension.
0
 
MightySWCommented:
You cannot do what you are asking for with this utility, but you can narrow it down, export to excel, and filter the response.

You can also do this with the dir command by just typing from the C:\ prompt: dir * /OD > c:\directory.txt

They take this .txt file and import it into excel and create a filter with your date specifications.

If you want to delete or move any of these files then you may want to look at powertoys or just do a search by oldest date modified and start from the last 3 years after you desire.

HTH
0
 
Bradley HaynesCommented:
Here are a number of file search utilities you can use:
http://file-search.qarchive.org/ 
0
 
MightySWCommented:
I still don't see why you cannot use the date range in 2003 or XP.  If you have Vista then you can do it with the advanced search syntax.

I have provided a screen shot showing what I did to just give me file names and not last modified directories.

HTH

search.jpg
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now