Re: Need a select command

[Denis L'Huillier]

For total data being managed by TSM I use:

select sum(physical_mb) from occupancy

Or if you want to know the total MB for nodes in schedules only you can
use:

select sum(physical_mb) from occupancy where node_name in (select node_name
from associations)

Regards,

Denis L. L'Huiller
973-360-7739
[EMAIL PROTECTED]
Enterprise Storage Forms ->
http://admpwb01/misc/misc/storage_forms_main.html



                    Robert Ouzen
                    <[EMAIL PROTECTED]        To:     [EMAIL PROTECTED]
                    IFA.AC.IL>             cc:
                    Sent by: "ADSM:        Subject:     Need a select command
                    Dist Stor
                    Manager"
                    <[EMAIL PROTECTED]
                    ST.EDU>


                    02/14/2002
                    03:39 AM
                    Please respond
                    to "ADSM: Dist
                    Stor Manager"






Hi

To select guru I need one for calculate the amount of data store in my
site.

 I run q auditocc but I need the total of each domain.

T.I.A Robert Ouzen

[EMAIL PROTECTED]