create sqltable Object.Ids object_ids
create sqltable BF.Aggregated.Bitfiles bfaggred_bitfiles

use ODBC driver to link/import these tables into MS Access or whatever
you prefer

SELECT OBJECT_IDS.C0 AS Object_ID, OBJECT_IDS.C5 AS HL, OBJECT_IDS.C6
AS LL, OBJECT_IDS.C8 AS Bitfile_Size, OBJECT_IDS.C9 AS
Bitfile_Header_Size, BFAGGRED_BITFILES.C4 AS Length_Of_Bitfile,
IIf([Length_Of_Bitfile] Is
Null,[Bitfile_Size],[Length_Of_Bitfile]-[Bitfile_Header_Size]) AS
User_File_Size
FROM BFAGGRED_BITFILES RIGHT JOIN OBJECT_IDS ON BFAGGRED_BITFILES.C1 =
OBJECT_IDS.C0 WHERE (((OBJECT_IDS.C8)<>"0"));

but this is not real user_file_size! just close to it...


--- "Rushforth, Tim" <[EMAIL PROTECTED]> wrote:
> We are also trying to figure this out.  The contents table contains a
> size
> but unfortunately it is the aggregate size.
>
> So what we have to do is from a TSM client, issue a q backup command
> which
> does tell you the file size - now this is ok if you only have a
> couple of
> servers that you need this information from ....
>
> It sure would be nice if you could do this with a sql query ....
> .... and if it told you the actual space being used in TSM - not the
> source
> file size - ie. Take into account compression.
>
> Tim Rushforth
> City of Winnipeg
>
> -----Original Message-----
> From: Prather, Wanda [mailto:[EMAIL PROTECTED]]
> Sent: February 22, 2002 2:10 PM
> To: [EMAIL PROTECTED]
> Subject:
>
> No.
> You can query the backups table to find a list of what was backed up,
> but
> the backups table doesn't show you the file size.
>
>
> -----Original Message-----
> From: Peppers, Holly [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 22, 2002 2:53 PM
> To: [EMAIL PROTECTED]
> Subject:
>
>
> We are trying to determine how much of our backup data is PST files.
> Can
> this be determined from the TSM database?  Thanks.
>
> Holly L. Peppers
> Bluse Cross & Blue Shield of Florida
> [EMAIL PROTECTED]
>
>
> Blue Cross Blue Shield of Florida, Inc., and its subsidiary and
> affiliate companies are not responsible for errors or omissions in
> this
> e-mail message. Any personal comments made in this e-mail do not
> reflect the
> views of Blue Cross Blue Shield of Florida, Inc.


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

Reply via email to