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
Author: Alex Paschal <AlexPaschal AT FREIGHTLINER DOT COM>
Date: Tue, 30 Jan 2001 12:14:06 -0800
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 Pas
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