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
