Hi Bill! Yes you can: 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 order by STORAGE_MB
Kindest regards, Eric van Loon KLM Royal Dutch Airlines -----Original Message----- From: Bill Dourado [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 12:36 To: [EMAIL PROTECTED] Subject: Re: report of usage of space in megabyte for every user... Eric, Its also what I was looking for, is it possible to sort output by occupancy ? Thanks Bill "Loon, E.J. van - SPLXM" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 07/10/2004 10:39 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Re: report of usage of space in megabyte for every user... 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:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 08:46 To: [EMAIL PROTECTED] 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. ********************************************************************** ********************************************************************** 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. **********************************************************************
