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 AT VM.MARIST DOT 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.