On Thu, 24 Nov 2005, Gary Osullivan wrote:

 > I'm looking for a SQL select statement that I could run against the tsm
 > database that would give me a list of tapes used per node ?

Here is one (replace NODENAME and STGPOOL as appropriate):

SELECT DISTINCT -
   CAST(volumeusage.volume_name AS CHAR(6)) as "Volume", -
   CAST(volumes.est_capacity_mb as decimal(6,0)) as "Capacity", -
   CAST(volumes.pct_utilized AS DECIMAL(4,1)) AS "% used", -
   CAST(volumes.status AS CHAR(7)) as "Status", -
   CAST(volumes.access AS CHAR(6)) as "Access", -
   DATE(volumes.last_write_date) as "Last write" -
  FROM volumeusage,volumes -
  WHERE volumeusage.node_name='NODENAME' -
    AND volumeusage.stgpool_name='STGPOOL' -
    AND volumeusage.volume_name=volumes.volume_name


If you're looking for a particular filespace, add a condition

   AND volumeusage.filespace_name='FILESPACE'

or

   AND volumeusage.filespace_name like ('%' || 'partial_filespace_name' || '%')

I prefer the latter, as I don't have to write down the exact filespace
name as TSM wants it.

   Rainer Schöpf