select * from volhistory where type='BACKUPFULL' and date_time>(current_timestamp-1 day)
You can use 'hour' instead of 'day' to get further granularity -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Roger Silva Sent: 25 May 2006 17:24 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select Statements Thank You Sandeep, I made changes since some of the fields didn't work for me, but this is what I have: SELECT DATE_TIME AS DATE,TYPE,VOLUME_NAME,LOCATION FROM VOLHISTORY WHERE TYPE='BACKUPFULL' But, what I would like to do is pull just the last or most current BACKUPFULL or BACKUPINCR information. I have been looking for some sort of a "CURRENT TIMESTAMP" or something on those lines? Is there something I can add to get this info? Rog On May 25, 2006, at 3:19 AM, Sandeep Jain wrote: > Hi, > You can use below select statement to view the full db backup > details. > > SELECT DATE_TIME AS "DATE TIME",TYPE,BACKUP_SERIES,VOLUME_NAME FROM > VOLHISTORY WHERE TYPE='BACKUPFULL' > > REPLACE 'BACKUPFULL' WITH 'BACKUPINCR' IF YOU TAKE INCREMENTAL > BACKUP > > With Best Regards, > Sandeep Jain > > > > ********************** Legal Disclaimer > *********************************************************************** > ***** > ****** > > "This email may contain confidential and privileged material for the > sole > use of the intended recipient. Any unauthorized review, use or > distribution > by others is strictly prohibited. If you have received the message in > error, > please advise the sender by reply email and delete the message. Thank > you." > > *********************************************************************** > ***** > ********* > > > > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of > Roger Silva > Sent: Thursday, May 25, 2006 1:54 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Select Statements > > > Hi, > > I am new to the this list and need some advice. > > I am trying to create a select statement I can run to monitor the > Database > Backups of our TSM Servers. I know there are fields in the SUMMARY > portion > of the table that has Start Time, End Time, Activity, Entity, Volume > Name > and Successful fields, but I am not sure as to how to put all this > together > in a nice script that can email to a group of > individuals the status. I am not sure if I need to query several > parts of the database in order to compile this info or not. > > Can anyone help me out? > > Thank You, > Roger > > > > This email has been scanned for any virus infection at the sending end. >
