OK, SQL Select gurus. I am trying to figure out, using the new summary
table in TSM 3.7, the select statement for how many bytes are backed up per
day for a given node. What I have so far is:
select cast((end_time)as date) as "Date", sum(bytes) as "Number of Bytes
for Node $1 Backed Up" -
from summary where activity='BACKUP' and days(end_time)-days(start_time)=0
and ENTITY='$1' -
group by end_time
This is not quite right - it produces one line for each filespace backed
up for each day for the given node. I want a TOTAL amount for each day for
the node. What do I need to do to modify the select to give me a total, for
a given node, of the number of bytes backed up for that day?
Money is not the root of all evil - full backups are.
|