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" <rbs AT BU DOT EDU>
To: <ADSM-L AT VM.MARIST DOT EDU>
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
>