Re: report of usage of space in megabyte for every user...

2004-10-08 Thread Richard Sims
>Thank you for your reply. I am agreee. I think it will take long time to >count up. I dont know where to find all this this file-owner >informations/attributes. There are some tables with fields named >'FILE_SIZE'. Hi, Peter - I have notes on FILE_SIZE and related topics in http://people.bu.edu/

Re: report of usage of space in megabyte for every user...

2004-10-07 Thread Peter K. Korsgaard
ot;Richard Sims" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 07, 2004 1:15 PM Subject: Re: report of usage of space in megabyte for every user... > On Oct 7, 2004, at 2:46 AM, Peter K. Korsgaard wrote: > > > Hi, > > > > I need to cr

Re: report of usage of space in megabyte for every user...

2004-10-07 Thread Richard Sims
On Oct 7, 2004, at 2:46 AM, Peter K. Korsgaard wrote: 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? Peter

Re: report of usage of space in megabyte for every user...

2004-10-07 Thread Loon, E.J. van - SPLXM
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&quo

Re: report of usage of space in megabyte for every user...

2004-10-07 Thread Bill Dourado
tor 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 = occupa

Re: report of usage of space in megabyte for every user...

2004-10-07 Thread Loon, E.J. van - SPLXM
. 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

report of usage of space in megabyte for every user...

2004-10-07 Thread Peter K. Korsgaard
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