I'm not an expert at SQL queries, but here is a script that I
use to see volume in the last 24 hours that is similar to yours. I will
give someone in the listserv credit for this, since I can't remember if
I stole it or made it myself:

                                         select summary.entity as "NODE
NAME" , nodes.domain_name as
                                 "DOMAIN" , nodes.platform_name as
"PLATFORM" ,
                                 cast((cast(sum(summary.bytes) as float)
/ 1024 / 1024) as
                                 decimal(10,2)) as MBYTES , count(*) as
"CONECTIONS" from summary
                                 ,nodes where
summary.entity=nodes.node_name and
                                 summary.activity='BACKUP' and
start_time >current_timestamp - 1
                                 day group by entity, domain_name,
platform_name order by MBytes
                                 desc       

Ben

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Dave Zarnoch
Sent: Tuesday, January 10, 2006 10:32 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Amount of data backed up per node

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