Hi Richard, 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'.
Best regards Peter ----- Original Message ----- From: "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 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 - Unfortunately, it's not possible to produce such a report > within the TSM server, > mostly because it would take enormous SQL processing time in > joining multiple > tables, but also because it's impossible to get file size information > from the server, > because of Aggregation. The only way you could begin to produce such a > per-user report > is from the client side. > > Richard Sims http://people.bu.edu/rbs >