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" <TRushfor AT CITY.WINNIPEG.MB DOT CA> wrote:
> We are also trying to figure this out. The contents table contains a
> 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:Wanda.Prather AT JHUAPL DOT EDU]
> Sent: February 22, 2002 2:10 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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:Holly.Peppers AT BCBSFL DOT COM]
> Sent: Friday, February 22, 2002 2:53 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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
> holly.peppers AT bcbsfl DOT com
>
>
> 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
|
