ADSM-L

Select statement question

2005-05-04 08:32:54
Subject: Select statement question
From: Dave Zarnoch <zarnocd AT NATIONWIDEPROVIDENT DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 4 May 2005 08:26:30 -0400
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

<Prev in Thread] Current Thread [Next in Thread>