ADSM-L

Re: help with sql

2001-12-20 12:00:49
Subject: Re: help with sql
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
Date: Thu, 20 Dec 2001 11:57:44 -0500
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...

<Prev in Thread] Current Thread [Next in Thread>