Re: select command for Successful / Failed backups
Q event -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath Sent: woensdag 10 januari 2007 6:25 To: ADSM-L@VM.MARIST.EDU Subject: select command for Successful / Failed backups Hi, 1) Is there any command to find the list of all failed backups in a server? 2) Is there any command to find the list of all successful backups in a server? Regards, Srinath G This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. ÿþD i t b e r i c h t i s v e r t r o u w e l i j k e n k a n g e h e i m e i n f o r m a t i e b e v a t t e n e n k e l b e s t e m d v o o r d e g e a d r e s s e e r d e . I n d i e n d i t b e r i c h t n i e t v o o r u i s b e s t e m d , v e r z o e k e n w i j u d i t o n m i d d e l l i j k a a n o n s t e m e l d e n e n h e t b e r i c h t t e v e r n i e t i g e n . A a n g e z i e n d e i n t e g r i t e i t v a n h e t b e r i c h t n i e t v e i l i g g e s t e l d i s m i d d e l s v e r z e n d i n g v i a i n t e r n e t , k a n A t o s O r i g i n n i e t a a n s p r a k e l i j k w o r d e n g e h o u d e n v o o r d e i n h o u d d a a r v a n . H o e w e l w i j o n s i n s p a n n e n e e n v i r u s v r i j n e t w e r k t e h a n t e r e n , g e v e n w i j g e e n e n k e l e g a r a n t i e d a t d i t b e r i c h t v i r u s v r i j i s , n o c h a a n v a a r d e n w i j e n i g e a a n s p r a k e l i j k h e i d v o o r d e m o g e l i j k e a a n w e z i g h e i d v a n e e n v i r u s i n d i t b e r i c h t . O p a l o n z e r e c h t s v e r h o u d i n g e n , a a n b i e d i n g e n e n o v e r e e n k o m s t e n w a a r o n d e r A t o s O r i g i n g o e d e r e n e n / o f d i e n s t e n l e v e r t z i j n m e t u i t s l u i t i n g v a n a l l e a n d e r e v o o r w a a r d e n d e L e v e r i n g s v o o r w a a r d e n v a n A t o s O r i g i n v a n t o e p a s s i n g . D e z e w o r d e n u o p a a n v r a a g d i r e c t k o s t e l o o s t o e g e z o n d e n . T h i s e - m a i l a n d t h e d o c u m e n t s a t t a c h e d a r e c o n f i d e n t i a l a n d i n t e n d e d s o l e l y f o r t h e a d d r e s s e e ; i t m a y a l s o b e p r i v i l e g e d . I f y o u r e c e i v e t h i s e - m a i l i n e r r o r , p l e a s e n o t i f y t h e s e n d e r i m m e d i a t e l y a n d d e s t r o y i t . A s i t s i n t e g r i t y c a n n o t b e s e c u r e d o n t h e I n t e r n e t , t h e A t o s O r i g i n g r o u p l i a b i l i t y c a n n o t b e t r i g g e r e d f o r t h e m e s s a g e c o n t e n t . A l t h o u g h t h e s e n d e r e n d e a v o u r s t o m a i n t a i n a c o m p u t e r v i r u s - f r e e n e t w o r k , t h e s e n d e r d o e s n o t w a r r a n t t h a t t h i s t r a n s m i s s i o n i s v i r u s - f r e e a n d w i l l n o t b e l i a b l e f o r a n y d a m a g e s r e s u l t i n g f r o m a n y v i r u s t r a n s m i t t e d . O n a l l o f f e r s a n d a g r e e m e n t s u n d e r w h i c h A t o s O r i g i n s u p p l i e s g o o d s a n d / o r s e r v i c e s o f w h a t e v e r n a t u r e , t h e T e r m s o f D e l i v e r y f r o m A t o s O r i g i n e x c l u s i v e l y a p p l y . T h e T e r m s o f D e l i v e r y s h a l l b e p r o m p t l y s u b m i t t e d t o y o u o n y o u r r e q u e s t
Re: select command for Successful / Failed backups
On Jan 10, 2007, at 7:50 AM, Bos, Karel wrote: Q event Amen. This TSM tracking of Backup event success is one of the great benefits of using TSM client scheduling, as opposed to having an operating system scheduling subsystem perform backups. Centralized reporting and control. Richard Sims
Re: select command for Successful / Failed backups
- Original Message - From: Richard Sims [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Wednesday, January 10, 2007 2:20 PM Subject: Re: select command for Successful / Failed backups On Jan 10, 2007, at 7:50 AM, Bos, Karel wrote: Q event Amen. This TSM tracking of Backup event success is one of the great benefits of using TSM client scheduling, as opposed to having an operating system scheduling subsystem perform backups. Centralized reporting and control. Richard Sims absolutely agree, even my SOX reports are generated with q event :-) goran
Re: select command for Successful / Failed backups
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath 1) Is there any command to find the list of all failed backups in a server? 2) Is there any command to find the list of all successful backups in a server? From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bos, Karel Q event Well, let's narrow that down some: Q EVENT * * EXCEPT=YES will show only the failed and missed backups Q EVENT * * will show all backups, successful, failed, or missed. -- Mark Stapleton ([EMAIL PROTECTED]) Senior consultant
Re: select command for Successful / Failed backups
Yes, but only for today...since midnight last night until midnight today. Most backup windows span midnight..starting early evening and running through the morning. Use the BEGIND=,BEGINT=, ENDD= and ENDT= to get the range you need. Q EV * * BEGINT=-24 ENDD=+0 ENDT=NOW EX=YES Will show the missed/failed schedules for the last 24-hours. Bill Boyer -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mark Stapleton Sent: Wednesday, January 10, 2007 11:36 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: select command for Successful / Failed backups From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gopinathan, Srinath 1) Is there any command to find the list of all failed backups in a server? 2) Is there any command to find the list of all successful backups in a server? From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bos, Karel Q event Well, let's narrow that down some: Q EVENT * * EXCEPT=YES will show only the failed and missed backups Q EVENT * * will show all backups, successful, failed, or missed. -- Mark Stapleton ([EMAIL PROTECTED]) Senior consultant
Re: select command for Successful / Failed backups
Here's a nice select command to see more detailed information . So I don't take all the credit, this select was posted while back one time or other. You can play around with date # to increase or decrease # of days of report. select entity as node_name, date(start_time) as date, cast(activity as varchar(10)) as activity, - time(start_time) as start,time(end_time) as end, - cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as Length,- cast(bytes/1024/1024/1024 as decimal(6,2)) as - Gigabytes,cast(affected as decimal(7,0)) as files, successful from summary where - start_time=current_timestamp - 1 day and activity='BACKUP' - order by successful, node_name I dont' think q event is a select statement. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/10/2007 12:25:10 AM: Hi, 1) Is there any command to find the list of all failed backups in a server? 2) Is there any command to find the list of all successful backups in a server? Regards, Srinath G This e-mail has been scanned for viruses by the Cable Wireless e- mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www. cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e- mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies.