"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 07/25/2006
09:15:39 AM:
> TSM 5.3.1 on win2K server. Isn't there a way to get the total data (MB)
> used by a username on all of the filespaces in a database? I'm thiking
> something like:
>
> select sum(capacity) filespace * where username=dudeman
>
> But that doesn't work because there is no username flag in filepsace
> table. Must be in some other table, but I can't find it. Any ideas?

It would not do much good; many files and directories in Windows boxes end
up owned by ADMINISTRATOR that you probably wouldn't get much in the way
of useful information.

However, you might be a good candidate for IBM's Total Productivity Center
for Data.

--
Mark Stapleton (mark.stapleton AT usbank DOT com)
US Bank MR Backup and Recovery Management
------------------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains 
information that is, or may be, covered by electronic communications privacy 
laws, and is also confidential and proprietary in nature. If you are not the 
intended recipient, please be advised that you are legally prohibited from 
retaining, using, copying, distributing, or otherwise disclosing this 
information in any manner. Instead, please reply to the sender that you have 
received this communication in error, and then immediately delete it. Thank you 
in advance for your cooperation.
==============================================================================