> On Tuesday 09 March 2004 10:25, Justin Case wrote: > > I have been trying to do a select command to query what client(node_name) > > is using how many tapes by count. > > So does any one want to share a query ? > > Thanks
"show volumeusage nodename" will list them for the primary pool. > > Justin, > > Try something like the following: > > select node_name, - > stgpool_name, - > count(distinct volume_name) as "TAPE_SPREAD" - > from volumeusage - > group by node_name, stgpool_name > > There's more like this at my TSM site, http://ibktsm.dyndns.org:81/sql.html > > Regards, > Steven P. > > -- > Steven Pemberton > Senior Enterprise Management Consultant > IBK, Senetas Group > > Mobile: +61/0 418 335 136 | Phone: +61/3 9820 5811 | Fax: +61/3 9820 9907 > Level 1, 11 Queens Road, Melbourne, Victoria, 3004, Australia > http://www.senetas.com.au | http://www.ibk.com.au | http://www.datum.com.au > > Steve Roder University at Buffalo ([EMAIL PROTECTED] | (716)645-3564)
