TSM - Select

[girreis]

Dear friends,

This script (SELECT) TSM Server 5.5 does fall?

SELECT COUNT (DISTINCT volume_name) the volumes, node_name, stgpool_name -
volumeusage from -
group by node_name, stgpool_name -
order by desc volumes

Thanks for listening,
Ramon

 

[fuzzballer]

Is this what you are trying to do?

select distinct volume_name, node_name, stgpool_name from volumeusage group by node_name, stgpool_name, volume_name order by volume_name desc