"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.
==============================================================================
|