I use following: dsmadmc > Select sum(cast(bytes/1024/1024 as decimal(10,3))) as "Backuped MB" from summary where start_time>current_timestamp - 1 day and activity='BACKUP'
The above is 1 long line. If runnig from within a script run dsmadmc with -ID -PASSW and -DATAONLY=YES Parameters regards juraj -----Ursprüngliche Nachricht----- Von: Justin Case [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 30. März 2004 17:37 An: [EMAIL PROTECTED] Betreff: 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