ADSM-L

Re: TSM Backup Script, bytes sent over last session.

2002-02-12 12:27:59
Subject: Re: TSM Backup Script, bytes sent over last session.
From: "Williams, Tim P {PBSG}" <Tim.Williams AT PBSG DOT COM>
Date: Tue, 12 Feb 2002 11:24:52 -0600
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


<Prev in Thread] Current Thread [Next in Thread>