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
