Version 7.1
James Lepre
Infrastructure Support Specialist
Solix, Inc. | 30 Lanidex Plaza West | Parsippany, NJ 07054
T: 973.581.5362 | F: 973.599.6544
www.solixinc.com | Solix on Facebook | Solix on Twitter
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Rick Saylor
Sent: Tuesday, June 24, 2014 3:19 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Select Statement Help
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,4
>969,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
|