Andy, thanks for the double checking, I'll weed out the other info and see what I get.
Thanks, Ben -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Raibeck Sent: Thursday, October 26, 2006 4:31 PM To: [email protected] Subject: Re: Script check requested. Off the top of my head, I don't see anything inherently wrong with the script (syntax-wise). However, if you are going after just backup or archive info, then you are gboing to pick up a lot more than that. Try adding a WHERE clause like this: ... where activity in ('ARCHIVE', 'BACKUP') Or if you want to split them out, add the ACTIVITY column to the SELECT output, and add this after the WHERE clause: ... group by activity Thus: select activity, \ cast((cast(sum(bytes) as double) / 1024 / 1024 /1024) as decimal(10,2)) as "Gigabytes" \ from summary \ where activity in ('ARCHIVE', 'BACKUP') and \ start_time>current_timestamp - 1 day \ group by activity Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageMan ager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 10/26/2006 03:08:02 PM: > Folks, > I have a script I have run forever to see how much data has been > backed-up/archived to my TSM servers over the last 24 hours. > > Lately, this command is returning a number that seems to be too > high, compared to what I see the clients doing. > > > select cast((cast(sum(summary.bytes) as float) / 1024 / 1024 /1024) > as decimal(10,2)) as Gigabytes from > summary where start_time > >current_timestamp - 1 day > > > I recently upgraded my TSM servers from 5.2 to 5.3 and was > wondering if that had anything to do with it. > > This SQL statement looks OK to me. Can anyone point out any > problems with that select statement? > > Thanks, > Ben
