Select statement question
2005-05-04 08:32:54
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>
|
- Select statement question,
Dave Zarnoch <=
|
|
|