Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Jun 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Report on Archived/Backed-up Files with All Details

    Hi All,

    What query/select will give times of creation and modification (of the file itself) for the archived or backed up files ?

    I wasn't sure where to post it, but since the result will be called a report...
    I have been asked by some customer to prepare report showing list of archived files from a specified directory (with sub-directories) with all details:
    Backup/Archiving date, Path, Name, "Created" Time, and "Modified" Time.
    There is no problem with all of those but the file ctime and mtime information.
    I was checking BACKUPS and ARCHIVES tables - there are only dates/times when a file was backed up or archived by TSM.
    Though this information is somewhere there because with the GUI Client one can display all those details. But this client is not suitable to produce report containing large number of files/versions.

    I will appreciate any hints.

    Marek Kulczycki

  2. #2
    Member
    Join Date
    Jun 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    To get all (available) details of files backed up or archived:

    dsmc q backup '/*' -sub=y -detail
    dsmc q archive '/*' -sub=y -detail

    There is no (official) way to access this data from server, running some 'dsmadmc select * from ...'

Similar Threads

  1. Custom report with missed file details
    By Lars_Svensson in forum TSM Reporting & Monitoring
    Replies: 14
    Last Post: 11-22-2007, 11:53 AM
  2. Report of Total backed up by platform
    By wchavis in forum TSM Reporting & Monitoring
    Replies: 3
    Last Post: 12-11-2006, 01:09 PM
  3. Report: Detailed List of Backed up Files
    By astrotrain in forum TSM Reporting & Monitoring
    Replies: 1
    Last Post: 03-31-2006, 11:46 AM
  4. Deleting Archived files
    By mricca in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 04-13-2005, 04:27 PM
  5. Report for number of servers backed up within 24 hrs.
    By ramseydc in forum TSM Reporting & Monitoring
    Replies: 1
    Last Post: 01-27-2005, 08:59 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •