Hi Peter!
Is this what you are looking for?

select occupancy.node_name, sum(logical_mb) as STORAGE_MB from nodes,
occupancy where nodes.node_name = occupancy.node_name group by
occupancy.node_name

Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines

-----Original Message-----
From: Peter K. Korsgaard [mailto:Pkk AT DMI DOT DK]
Sent: Thursday, October 07, 2004 08:46
To: ADSM-L AT VM.MARIST DOT EDU
Subject: report of usage of space in megabyte for every user...


Hi,

I need to create a report in TSM DSMADMC. A report of usage of space in
megabyte for every user nomatter in what partition/filespace files of each
user are located. Do any no if it possible to write a sql-query for this and
how?

example...


User      Num Files       Space(MB)

MAS          108757        7886697
JBC           124354        9112554
CLI            325567       12543546

Total          558678       29542797


Regards

Peter


**********************************************************************
For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), 
its subsidiaries and/or its employees shall not be liable for the incorrect or 
incomplete transmission of this e-mail or any attachments, nor responsible for 
any delay in receipt.
**********************************************************************