How to find out number of backed up versions of all files of a node.

[mohit]

Hi All,



I need a select statement to know how many versions of a file are backed up currently on TSM. I need this information for all files on a node.



I have been trying on table 'BACKUPS' with group by and count etc. but no success yet. Any help is welcome.



TIA,

Mohit.. .

 

[izak]

This should do it:



select HL_NAME,LL_NAME, count(OBJECT_ID) as NumberOfBackups from BACKUPS where node_name='<NODE NAME>' group by HL_NAME,LL_NAME