You're on an old version of the server code. Somewhere back around that level there was a bug that made the data in the summary table unreliable. You may be seeing that bug.
David >>> [EMAIL PROTECTED] 01/10/06 12:32 PM >>> 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
