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

 

[klee]

Try this -



select filespace_name, hl_name, ll_name, count(*) from backups where node_name='XYZ' and type='FILE' group by filespace_name, hl_name, ll_name



It is case sensitive for node_name and type and may take some time for your larger nodes.