> 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
(spr AT buffalo DOT edu | (716)645-3564)
|