• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Archiving Data

I am using Arcserv to Archive data by using the Global Options. Is there a way to run a report by Modified file date? I have to give a report to management stating what files will be archived prior to the actual run. I looked at the Arcserv report and do't see anything that can be ran for file Modification date. Thanks!
Darrell Kirby
Darrell Kirby
  • 4
1 Solution
What do you mean by archiving - a simple backup copy or deletion and eternal copy?
Darrell KirbyAuthor Commented:
A deletion of records with a Modify date of 2006 and prior. I need to run a report and present to management showing these files prior to the deletion run.
Hi Jim

I know nothing about the backup program you are referring to, but there are a number of ways you could create a report independently using a simple "DOS" batch file or a VBScript.  We would have to assume that the "Last Modified" dates found by the Arcserv program will match those found by windows CMD.exe and a VBScript, and that is something that I could not test.

First of all, in Windows XP (maybe Win2000) and later the DIR command allows you to specify which of the Windows Dates are used to sort files.  DIR /?

Example batch file that lists all file types in the given path and all sub-directories, excludes all results containing file 4-digit years of 2006 to 2001 and sorts the results by "last written" date with the oldest first.

@echo off
echo Creating File List report ...
dir /a-d /od /tw /s /4 "C:\FolderName\*.*">"C:\_FileReport.txt"

That includes all the DIR headers and splits the results into groups per-folder, but you can use that basic command and filter the results to compile a neat CSV list with just the file path and name, and the "last written" date.  A batch file can be given if you would like to try this.

The other commonly used method is a CVScript that uses the FileSystemObject.  If you look at the suggestion given by Richard MuellerMVP, Moderator, on Tuesday, November 17, 2009 3:42 AM here:
then you will find the code for a VBS file that allows you to specify a date (in the form MM/DD/YYYY) as your "files older than" point and which produces a listing of all files in the specified folder and all sub-folders with the "Modified" date prior to that date.  Optionally, and remarked out in the given code, is the option to delete the file if it is older than the given date.

Is that something you could use?
Would you like any explanations of how that VBS file works?

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

The requirement in the above VBS file was to list files OLDER than the given date.  If you changed the < to > in the line:
        If (objFile.DateLastModified < dtmDate) Then
it would list files NEWER than the given date, and that may provide you with a cross-check with what would be archived.
Sorry, I was typing too fast and still thinking about CSV files.  Where I referred to "CVScript" it should have been "VBScript".
Hmmm.  Seems like a logical choice to accept a comment that just asks a question.

Featured Post

Technology Partners: 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!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now