Hi, the option below worked, thanks for that. But is there a way to send the output from the select command to issue the move command to checkout tapes? select volume_name from volhistory where Date(date_time)=date(current_timestamp) type='BACKUPFULL' location<>'VAULT' move drmedia * tost=vault Thanks again:) -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> ] On Behalf Of Das, Samiran (IDS ECCS) Sent: Wednesday, October 06, 2004 12:19 PM To: ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> Subject: Re: select command
Or this one if you want to see volumes from today's backup. select volume_name from volhistory where Date(date_time)=3Ddate(current_timestamp) and type in ('BACKUPFULL','BACKUPINCR') Or may be a simpler one. Q volhist begind=3Dtoday type=3Ddbb Regards, Samiran Das -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> ] On Behalf Of Das, Samiran (IDS ECCS) Sent: Wednesday, October 06, 2004 12:19 PM To: ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> Subject: Re: select command Rachel, Try this select query. select volume_name from volhistory where date_time<timestamp(date(current_timestamp),'00:00') and type in ('BACKUPFULL','BACKUPINCR') Following pdf By Andrew Reibeck is the best place to start with tsm sql. http://www-dat.lrz.de/dat/8/asys/doc/tsmserv/adsmserv-sql/doc/pdf/adsm_s <http://www-dat.lrz.de/dat/8/asys/doc/tsmserv/adsmserv-sql/doc/pdf/adsm_ s> ql.pdf Regards, Samiran Das -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> ] On Behalf Of Smith, Rachel Sent: Wednesday, October 06, 2004 11:31 AM To: ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> Subject: select command Hi, =20 I am trying to complete a select command to "select volume_name from volhistory where type=3D'backupfull' and date_time>'today'" which fails because today is incorrect, can you tell me the correct format. Also when the above runs successfully, I will require it to use the out but from the select command to move the media to tost=3Dvault. =20 Any ideas on how to do this or a web site that helps us understand SQL better? =20 Thanks..=20 -------------------------------------------------------- =20 If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/=20 <http://www.ml.com/email_terms/=20> --------------------------------------------------------=20 -------------------------------------------------------- =20 If you are not an intended recipient of this e-mail, please notify the = sender, delete it and do not read, act upon, print, disclose, copy, = retain or redistribute it. Click here for important additional terms = relating to this e-mail. http://www.ml.com/email_terms/=20 <http://www.ml.com/email_terms/=20> -------------------------------------------------------- =20