Author: Gary Osullivan <gary.osullivan AT STANDARDLIFE DOT CA>
Date: Thu, 24 Nov 2005 12:58:59 -0500
hi 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 ? It looks like I have few nodes that are eating up all my scratch
Author: Rainer Schöpf <rainer.schoepf AT PROTEOSYS DOT COM>
Date: Thu, 24 Nov 2005 19:10:24 +0100
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", - CAS
Gary - See topic "Node, volumes in use by" in http://people.bu.edu/ rbs/ADSM.QuickFacts You can also readily track client storage utilization through the TSM accounting records. Richard Sims hi I'm l