Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*sql\s+select\s+for\s+tapes\s+per\s+node\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*sql\s+select\s+for\s+tapes\s+per\s+node\s*$/: 4 ]

Total 4 documents matching your query.

1. sql select for tapes per node (score: 1): 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-11/msg00544.html (10,674 bytes)
2. Re: sql select for tapes per node (score: 1): 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-11/msg00546.html (11,727 bytes)
3. Re: sql select for tapes per node (score: 1): Author: Richard Sims <rbs AT BU DOT EDU>; Date: Thu, 24 Nov 2005 13:18:03 -0500; 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; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-11/msg00547.html (11,186 bytes)
4. Re: sql select for tapes per node (score: 1): Author: Aleem <aleem.unix AT GMAIL DOT COM>; Date: Thu, 24 Nov 2005 23:55:08 +0530; Just check for nodes having more occupancy in the occupancy table.. rgds, Aleem; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2005-11/msg00548.html (11,575 bytes)

Current List: 1 - 4
Page: [1]