Report on Archived/Backed-up Files with All Details

[markul]

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

[markul]

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 ...'