Interesting...I just installed TSM 5.2.2.1 for a client and the SHOW VOLUMEUSAGE command doesn't work for some nodes. They have 4 Exchange servers, each has 2 nodenames defined for it. The SHOW VOLUMEUSAGE on the nodename assigned to the TDP backups works just fine, but if I run it against the non-TDP nodename I get no results. A select on the volumeusage table gives me the information though. I would open a PMR with IBM/Tivoli, but SHOW commands are undocumented.
Bill Boyer DSS, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Steve Roder Sent: Tuesday, March 09, 2004 7:29 AM To: [EMAIL PROTECTED] Subject: Re: tsm select question ? > 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)
