This is a query from the TSM v6.3 agent:
select node_name, count(distinct volume_name) from volumeusage a, stgpools b where (a.stgpool_name=b.stgpool_name) and devclass in (select DEVCLASS_NAME from devclasses where devtype in ('3570','3590','3592','4MM','8MM','DLT','DTF','ECARTRIDGE','GENERICTAPE','LTO','QIC')) group by node_name
Could you run it on a TSM v5.x.x.x productive system for me!
Do you get any result in 10 minutes?
