Backup Central

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.

James,

set summaryretention xx

Merry Christmas

Bob.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On Behalf Of Lepre, James
Sent: Thursday, December 22, 2011 10:05 AM
To: ADSM-L < at > VM.MARIST.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.

Carefully consider extending the retention on the Summary table, as the amount of data can be large, taxing your database. What I prefer to do is keep a smallish Summary table, given that the need to query old data is rare, where I keep 30 days of Activity Log data in the database and older days as text files stored in HSM, which I can grep or analyze for historic information. The TSM accounting records are a further good source of historic statistical info on client sessions.

Richard Sims still plugging away at Boston University