ADSM-L

select total data owned by a username?

2006-07-25 10:16:21
Subject: select total data owned by a username?
From: Alexander Lazarevich <alazarev AT ITG.UIUC DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 25 Jul 2006 09:15:39 -0500
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?

Thanks,

Alex

<Prev in Thread] Current Thread [Next in Thread>