James,

What version of TSM? Your select statement will work in TSM 6.3 if
you change "start_time" to "date_time". Please note that I did not
verify the output, only that I got output.

Rick

At 01:39 PM 6/24/2014, you wrote:

Hello Everyone -

I am attempting miserably I might add to write a select statement
that will produce a bunch of message found in the actlog.  The
problem I am having is grabbing the data from the last 24 hours..  I
will schedule this to produce an email each day.. Any thoughts on
how to construct this

Thank you

SELECT * FROM ACTLOG WHERE (MSGNO IN
(406,4952,4954,4958,4960,4957,4970,4959,4961,4965,4963,4966,4967,4968,4969,4964,
4976, 4981)) and start_time>=current_timestamp - 24 hours

James Lepre





---------------------------------------------------------------
Confidentiality Notice: The information in this e-mail and any
attachments thereto is intended for the named recipient(s)
only.  This e-mail, including any attachments, may contain
information that is privileged and confidential  and subject to
legal restrictions and penalties regarding its unauthorized
disclosure or other use.  If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
the taking of any action or inaction in reliance on the contents of
this e-mail and any of its attachments is STRICTLY PROHIBITED.  If
you have received this e-mail in error, please immediately notify
the sender via return e-mail; delete this e-mail and all attachments
from your e-mail  system and your computer system and network; and
destroy any paper copies you may have in your possession. Thank you
for your cooperation.

----------------------------------------------------------------------------
Rick Saylor                  Austin Community College   Voice: (512)223-1182
Director of System Services  9101 Tuscany Way           Fax:   (512)223-1211
Information Technology       Austin, Texas  78754