Thank you very much! I think that will give me everything I need.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Raibeck
Sent: Thursday, May 20, 2004 12:47 PM
To: [EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]> 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
