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
|