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