Hi Debbie, I'm pretty sure that BETWEEN should work. If you could copy & paste in the command you entered and the output you received, that will give me a better picture of what is going on.
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] 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 2005-06-22 06:17:17: > this works really well, thank you. > > I've tried to narrow the current_timestamp to between the hours of 19:00 > in the evening and 06:00 in the morning. However, the command doesn't like > 'between'. Do you know what type of database this is? All I've ever worked > on is oracle databases. I was able to establish an ODBC connection to the > TSM db, yesterday, but it took very long to get any information back that > was filtered or sorted. > > > > > > Curtis Stewart <[EMAIL PROTECTED]> > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > 06/21/2005 04:34 PM > Please respond to "ADSM: Dist Stor Manager" > > > To: [email protected] > cc: > Subject: Re: [ADSM-L] Backup Information > > > Try this on for size. > > select entity as Node_Name, Schedule_name, substr(cast(start_time as > char(26)),1,19) as Start_Time, substr(cast(end_time as char(26)),1,19) as > End_Time, (end_time - start_time) minutes as Duration, examined as > Examined, affected as Backed_Up, failed as Failed, cast(bytes/1024/1024 as > integer) as MB, successful from summary where start_time !< > (current_timestamp - 1 day) and upper(activity)='BACKUP' > > [EMAIL PROTECTED] > > > > Debbie Bassler <[EMAIL PROTECTED]> > Sent by: "ADSM: Dist Stor Manager" <[email protected]> > 06/21/2005 03:10 PM > Please respond to > "ADSM: Dist Stor Manager" <[email protected]> > > > To > [email protected] > cc > > Subject > Backup Information > > > > > > > I was looking at the database tables and trying to find a way to get the > node names, backup start and end times and the amount of data backed up, > into an excel spread sheet. We backup over 100 servers a night and the > operations people manually go throught the activity log to find, and > record, this info. Just starting this job, I haven't had extra time to > go through any utilites or macros (I'm not even sure where to find them at > this point) that might supply this info. How does everyone else collect > this info? > > Currently, we are on TSM 5.1.1 and I'm planning to go to 5.1.9 soon. I > understand there is some reporting capability there....Eventually, we'll > get off AIX 4.3.3 and will be able to use a higher version of TSM....but > until that time I need to make the best of it,,,, > > Thanks, > Debbie
