ADSM-L

Re: PERL question for dsmaccnt.log queries ?

2004-03-30 10:46:33
Subject: Re: PERL question for dsmaccnt.log queries ?
From: Amos Hagay <amos AT CCC.CO DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 30 Mar 2004 17:41:33 +0200
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