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 [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703
