You can suck what you need out of this. ... It is one
I found on the list ... But use the logic and
you can roll your own ... JC
/************************************************/
/* Script that reports all the objects that are */
/* backed up for each node */
/************************************************/
set sqlmathmode round
set sqldatetimeformat eur
select entity as "Node", -
substr(cast(avg(end_time-start_time) -
as varchar(17)),3,8) as "Elapsed", -
cast(avg(affected) as decimal(7,0)) as -
"Avg Obj", -
case -
when avg(bytes) > 1073741824 then -
cast(cast(avg(bytes)/1073741824 as -
decimal(7,3)) as varchar(24))||' Gb' -
when avg(bytes) > 1048576 then -
cast(cast(avg(bytes)/1048576 as -
decimal(7,3)) as varchar(24))||' Mb' -
when avg(bytes) > 1024 then -
cast(cast(avg(bytes)/1024 as -
decimal(7,3)) as varchar(24))||' Kb' -
else cast(cast(avg(bytes) as -
decimal(7,3)) as varchar(24)) -
end as "Avg Bytes" -
from summary -
where activity='BACKUP' and -
successful='YES' -
group by entity
-----Original Message-----
From: Blair, Georgia [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: changeing bytes to gigabytes
I am using the summary table to monitor how much data migrates from disk on
a daily basis. What is the easiest way to find change the amount to
gigabytes versus bytes? Or does someone have a particular select statement
for this.
Thanks in advance
[EMAIL PROTECTED]
