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:[EMAIL PROTECTED]]
>Sent: Tuesday, January 30, 2001 12:16 PM
>To: [EMAIL PROTECTED]
>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.
