1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Report on Archived/Backed-up Files with All Details

Discussion in 'TSM Reporting & Monitoring' started by markul, Jul 13, 2008.

  1. markul

    markul New Member

    Joined:
    Jun 24, 2007
    Messages:
    8
    Likes Received:
    0
    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.  
  3. markul

    markul New Member

    Joined:
    Jun 24, 2007
    Messages:
    8
    Likes Received:
    0
    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 ...'
     
: ctime, mtime, query, report

Share This Page