Thanks Richard for pointing out the ADSM Faq - for subtracting time ... Our issue is we have OS backup backing up DB file systems via the OS backup schedule. (We have a separate node dbss0001 for the OS backup and a dbss0001-ORA for the RMAN backups. So we are going to use the query to Auto Ticket the Unix team for include Exclude challenges ---
SELECT START_TIME, END_TIME, SCHEDULE_NAME, ENTITY, BYTES FROM SUMMARY WHERE ACTIVITY='BACKUP' AND (CURRENT_TIMESTAMP-END_TIME)HOURS <= 16 HOURS and (SCHEDULE_NAME Is Not Null) and (BYTES >= 60000000000) -----Original Message----- From: Hart, Charles A Sent: Friday, January 16, 2009 10:04 AM To: ADSM-L@VM.MARIST.EDU Subject: SQL Select Stement Subtracting Time from Summary Table Is there a way to have a select statement perform much like the function of the q act begint=-8 ? I'm writing a SQL query to determine OS Backups are backing up DB files systems by doing a select from the summary table, with nodename, sched name, bytes recvd > 50GB etc, but need to find a way to say only look back x # of Hours ... I've even checked my SAL in 21Min book and cant find anything... Hope all is well with everyone and good luck in this new challenging year! Regards, Charles This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.