If I remember the summary table correctly, you must include a start date. Try one and see.
Dave Zarnoch <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 01/10/2006 10:28 AM Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> To ADSM-L@VM.MARIST.EDU cc Subject Re: Amount of data backed up per node I tried the macro that Ben sent, with the same results, there DOES appear to be a bug. Thanks! Does anyone know a way around besides upgrading? Dave Zarnoch Nationwide Provident [EMAIL PROTECTED] W 302-452-4197 C 302-462-8703 David E Ehresman <[EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU LLE.EDU> cc: Sent by: "ADSM: Subject: Re: [ADSM-L] Amount of data backed up per node Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 01/10/2006 12:59 PM Please respond to "ADSM: Dist Stor Manager" 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