Display number of days left for the last version of file - 'retain only version'

[rdemaat]

I'll admit I have only done a little work on this before coming here. I'll keep digging but I know this is the place to come for help. I have a large list of inactive files and folders (i.e. they have all been deleted from the source node - not all on the same date) with the 'retain only version' set to 180 days in the copygroup / mgmt class they are assigned to. Is there a way to display how much longer each one has to go before TSM removes that last version? RETONLY only shows up once in all the TSM tables. In the BU_COPYGROUPS table. Maybe some date calculation? Thank you!

 

[marclant]

Since you already know the retention, it should be fairly easy. The BACKUPS table has a DEACTIVATE_DATE, that's the date the file went inactive.

So you could do:

select field1, field2,...,180-(days(current_date)-days(deactivate_date)) from backups where state='INACTIVE_VERSION' and ...

 

[rdemaat]

Yes that is what I was looking for...Thank you!