Eric,
Its also what I was looking for, is it possible to sort output by
occupancy ?
Thanks
Bill
"Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
07/10/2004 10:39
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
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: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.
**********************************************************************
|