Thank you very much!  I think that will give me everything I need.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Andrew Raibeck
Sent: Thursday, May 20, 2004 12:47 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Query / Select help needed


How about something like this:

select stgpool_name,
       sum(num_files) as "Total Files",
       sum(physical_mb) as "Physical MB",
       sum(logical_mb) as "Logical MB"
   from occupancy
   where node_name='STORMAN'
   group by stgpool_name

(instead of STORMAN put in your node name in UPPER CASE)

If you know which storage pools in particular you want info for, and you
*don't* want to see other pools, then just add some conditions to the
WHERE clause, i.e. "where node_name='STORMAN' and stgpool_name='POOL1'
and stgpool_name='POOL2' ..." or "where node_name='STORMAN' and not
stgpool_name = 'DISKPOOLNAME' ..."

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 05/20/2004
08:56:20:

> Hello-
>
> I'm trying to determine a query or a select statement that will tell 
> me the total number of files managed by the TSM database for a 
> particular client, and the total amount of tape space occupied for 
> that client.
>
> q occ shows me the number of files and space occupied, but it isn't 
> totaled.  I need to obtain this information for over 300 clients, so I

> really don't want to have to add all of them manually.
>
> Can anyone help me out?  Is there a simple way to obtain the totals, 
> or am I going to have to write a shell script?
>
> Thanks!
>
> -Kevin