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

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