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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Steve Roder
Sent: Tuesday, March 09, 2004 7:29 AM
To: ADSM-L AT VM.MARIST DOT EDU
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
(spr AT buffalo DOT edu | (716)645-3564)