True. What I would really like to do is use the end_time, but with some
sort of a substring function to indicate only look at the first 10
characters. Evidently, using cast or substring with group is invalid. I've
tried several other fields(entity, etc) and all come up with errors.



At 12:14 PM 1/30/2001 -0800, you wrote:

Hi, Dave.  I notice you're grouping by End_Time. I'll bet that it's very
unlikely for all the filespaces of a node to finish backing up at the same
time.  What else have you tried grouping by?

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail

-----Original Message-----
From: Dave Canan [mailto:ddcanan AT ATTGLOBAL DOT NET]
Sent: Tuesday, January 30, 2001 12:16 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Total amount of bytes backed up per day for a node


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.

Money is not the root of all evil - full backups are.