I like this one that I cooked up: ANS8000I Server command: 'select date(days(current_date)-1) as "DATA date", summary.entity, nodes.domain_name, nodes.platform_name, sum(summary.bytes) as sum_bytes from summary, nodes where summary.entity=nodes.node_name and summary.activity='BACKUP' and days(current_date)-days(start_time)=1 group by summary.entity, nodes.domain_name, nodes.platform_name' order by sum_bytes desc
you can play with backup vs archive data.... it will pull all nodes info....prior day...24 hour period... FYI Thanks Tim -----Original Message----- From: P�tur Ey��rsson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 11:17 AM To: [EMAIL PROTECTED] Subject: TSM Backup Script, bytes sent over last session. I know this has been posted here a hundred times but i would like it wery mutch if somone nice would send me a admin script, that displays the amount of data sent thourh the last 24hrs for nodes? Kvedja/Regards Petur Eythorsson Taeknimadur/Technician IBM Certified Specialist - AIX Tivoli Storage Manager Certified Professional Microsoft Certified System Engineer [EMAIL PROTECTED] Nyherji Hf Simi TEL: +354-569-7700 Borgartun 37 105 Iceland URL: http://www.nyherji.is
