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:[email protected]] On Behalf Of Rick Saylor Sent: Tuesday, June 24, 2014 3:19 PM To: [email protected] 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
