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" <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.
**********************************************************************