Folks, I have a select statement that I use to determine the amount of MB backed up during a specific time period:
(e.g.) SELECT entity AS "Node name",CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB xfer" FROM summary WHERE activity='BACKUP' AND start_time>= '2005-04-01 06:00' AND end_time<= '2005-04-07 06:00' GROUP BY entity How would I include the "Policy Domain Name"? Thanks! DaveZ
