Thanks you all very much for replies.

Justin




Amos Hagay <amos AT CCC.CO DOT IL>@VM.MARIST.EDU> on 03/30/2004 10:41:33 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:    "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:    ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:    Re: PERL question for dsmaccnt.log queries ?

Use can use the TSM reporter or run the a select sentence :

select entity as Node,sum(bytes)/1024/1024 as MB from summary where
(activity='BACKUP' or activity='ARCHIVE') and
cast((current_timestamp-end_time)hours as decimal)<24 group by entity

Best Regards
               Amos Hagay





Amos Hagay
Services & Support

Tel: 972-(0)3-9201200 Fax: 972-(0)-3-9201281
Direct: 972-(0)3-9201292 Mobile: 972-(0)56-951309
www.ccc.co.il


-----Original Message-----
From: Justin Case [mailto:justin.case AT DUKE DOT EDU]
Sent: Tuesday, March 30, 2004 5:37 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: PERL question for dsmaccnt.log queries ?

Hi all I am not a PERL programmer so I could use some help with a script
that would query the
TSM accounting log (dsmaccnt.log) to pull out the amount of data backed
up
in a 24 hour period (last 24 hours).
If someone could share it with me that would be great. Or if someone
knows
of a better method
to compute the daily amount of data backed up by TSM server too..

Thanks

Justin