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