ADSM-L

Re: [ADSM-L] Select Statement

2011-12-22 11:46:14
Subject: Re: [ADSM-L] Select Statement
From: Bob Levad <blevad AT WINNEBAGOIND DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 22 Dec 2011 16:40:26 +0000
James,

set summaryretention xx

Merry Christmas

Bob.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Lepre, James
Sent: Thursday, December 22, 2011 10:05 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Select Statement

Does anyone know how to take this select command which produces only one month 
of data and allow it to go back say 1 year if possible. I have tried to figure 
it out but nothing works

select date(start_time) as "Start Date",time(start_time) as "Start 
Time",date(end_time) as "End Date",time(end_time) as "End Time",number as 
"Process #",activity,schedule_name,entity,bytes,successful from summary where 
schedule_name='SchedNAME'

Thanks Everyone and Happy Holidays



---------------------------------------------------------------
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.
This electronic transmission and any documents accompanying this electronic 
transmission contain confidential information belonging to the sender. This 
information may be legally privileged. The information is intended only for the 
use of the individual or entity named above. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or the taking of any action in reliance on or regarding the contents of this 
electronically transmitted information is strictly prohibited.

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