The following select was pulled from this list;
/* */
select case when SUM(BYTES) IS NOT NULL then CAST(SUM(BYTES) AS -
DEC(40,2))/(1024*1024*1024) else ABS(CAST((0) AS -
DEC(40,2))) end AS Total Gigabytes from summary -
where DAY(end_time) =
running it on March 10, and the oldest I found was for February 8.
-Original Message-
From: Shannon Bach [SMTP:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 9:41 AM
To: [EMAIL PROTECTED]
Subject: Select statement using last month's summary
The following select was pulled from
Thanks Jack!
It worked great! I was able to go back 31days as that is how much summary
log that I keep. Normally, I have a script which runs in my morning
process that sends a daily summary of GB's backed-up to a log, which I
eventually use for historical reporting. Because of a problem in