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
lau AT vt DOT edu