Searching for specific directories and files from TSM server for a client

[djr1111]

Hi,

Is there an easy way to search a client for lets said specific files backed up on a specific day or something in that nature from the TSM server. May be a cool select statement or some other command that can give a more broad output of not just today's backup results of that file/directory.

I know that I can see it from the client, but since I do not have access to the client I have to do it from the server.

Thank you for the help!!

 

[sandeepkontham]

try select * from backups
where you can get the filename==hl_name and backupdate, active or inactive and many more

ex:
select * from backups where backup_date=<date> or select * from backups where hl_name=<file_name>