What you may be running into is that at certain levels of the client, they were not reporting correctly to the TSM server when they were done as to their actual statistics. I'm not sure what client levels it was at, but I believe it was the 5.1.x.x versions. You might try a TSM client on one of the nodes and see if it starts reporting correctly.
Ben -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dave Zarnoch Sent: Tuesday, January 10, 2006 11:28 AM To: ADSM-L@VM.MARIST.EDU 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
