Strange. Your query worked for me (with a different nodename), although I had to add the date to restrict the output to the last 7 hours:
tsm: SSDADSM>select date_time, message from actlog where nodename='PRATHW1' and time(actlog.date_time) >= current_time - 7 hours and date(actlog.date_time)= current_date If you do: q actlog search=VTCAT.CC.VT.EDU begintime=now-7 Do you get anything back? Should be the same records in both cases... -----Original Message----- From: Eliza Lau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:20 PM To: [EMAIL PROTECTED] Subject: help with sql Hi TSMers, Can someone help me with with the following. I am trying to select from the actlog all entries for a client in the past 7 hours and send them to the user in a daily report. I may not be doing the sql select right. Nothing is selected even though the client just did a backup. => cat a.mac set sqldisplaymode wide select date_time, message from actlog where nodename='VTCAT.CC.VT.EDU' and time(actlog.date_time) >= current time - 7 hours tsm: ADSM>macro a.mac ANS8000I Server command: 'set sqldisplaymode wide' ANS8000I Server command: 'select date_time, message from actlog where nodename='VTCAT.CC.VT.EDU' and time(actlog.date_time) >= current time - 7 hours' ANR2034E SELECT: No match found using this criteria. ANS8001I Return code 11. ANS8029E Macro processing terminated. Thanks, Eliza Lau Virginia Tech Computing Center 1700 Pratt Drive Blacksburg, VA 24060 [EMAIL PROTECTED]
