"ADSM: Dist Stor Manager" <[email protected]> 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 ([EMAIL PROTECTED]) 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. ==============================================================================
