Amount of data backed up per node
2006-01-10 12:32:40
I want to print out the amount of data that each node backs up daily.
I have a macro that I THOUGHT was working properly but some nodes are now
showing
0 MB transferred when I know his is not true.
Here's the macro:
SELECT entity AS "Node name",CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS
"MB xfer" FROM sum
mary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours
GROUP BY entity
What's wrong with this?
Server Version 5, Release 1, Level 6.2
Thanks!
Dave Zarnoch
Nationwide Provident
zarnocd AT nationwideprovident DOT com
W 302-452-4197
C 302-462-8703
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Amount of data backed up per node,
Dave Zarnoch <=
|
|
|