ADSM-L

Re: [ADSM-L] Is their a way to find out - when was the last time a restore was performed for a TSM node.

2007-11-12 10:35:50
Subject: Re: [ADSM-L] Is their a way to find out - when was the last time a restore was performed for a TSM node.
From: Andrew Raibeck <storman AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 12 Nov 2007 08:34:57 -0700
Suggested modification:

   select * from summary where activity='RESTORE' and 
entity='<insert_node_name_here>' order by start_time desc

Replace <insert_node_name_here> with the desired node name in all 
upper-case.

Alternatively you can order by end_time, depending on whether it is 
important to know when the last restore operation started or ended.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development
Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page: 
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/12/2007 
08:26:21 AM:

> Run this statement...
> SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE' 
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On 
> Behalf Of Kamran Rao
> Sent: Monday, November 12, 2007 8:25 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Is their a way to find out - when was the last
> time a restore was performed for a TSM node.
> 
> It is for a restore. 
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On 
> Behalf Of CAYE PIERRE
> Sent: Monday, November 12, 2007 10:23 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Is their a way to find out - when was the last
> time a restore was performed for a TSM node.
> 
> Sorry I miss a word... It is for backup only, not restore 
> 
> > -----Message d'origine-----
> > De : ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] De la 
> > part 
> > de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À : 
> > ADSM-L AT VM.MARIST DOT EDU Objet : Re: [ADSM-L] Is their a way to find out 
> > - 

> > when was the last time a restore was performed for a TSM node.
> > 
> > I am sure I must be missing something obvious, else I am going to 
> > learn a new trick... how do you determine from QUERY FILESPACE F=D 
> > when a node last performed a restore?
> > 
> > Regards,
> > 
> > Andy
> > 
> > Andy Raibeck
> > IBM Software Group
> > Tivoli Storage Manager Client Product Development Level 3 Team Lead 
> > Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet 
> > e-mail: storman AT us.ibm DOT com
> > 
> > IBM Tivoli Storage Manager support web page: 
> > http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli
> > StorageManager.html
> > 
> > The only dumb question is the one that goes unasked.
> > The command line is your friend.
> > "Good enough" is the enemy of excellence.
> > 
> > "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/12/2007
> > 07:49:17 AM:
> > 
> > > That did the trick. Thanks for the tip
> > > 
> > > Regards,
> > > 
> > > Kamran
> > > 
> > > -----Original Message-----
> > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> > On Behalf
> > > Of CAYE PIERRE
> > > Sent: Monday, November 12, 2007 4:07 AM
> > > To: ADSM-L AT VM.MARIST DOT EDU
> > > Subject: Re: [ADSM-L] Is their a way to find out - when was
> > the last
> > > time a restore was performed for a TSM node.
> > > 
> > > You can also query filespaces : q fi f=d
> > > 
> > > > -----Message d'origine-----
> > > > De : ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] De la 
> > > > part de Kamran Rao Envoyé : vendredi 9 novembre 2007 21:12 À :
> > > > ADSM-L AT VM.MARIST DOT EDU Objet : [ADSM-L] Is their a way to
> > find out -
> > > > when was the last time a restore was performed for a TSM node.
> > > > 
> > > > Hello,
> > > > 
> > > > 
> > > > 
> > > > Just curious to know if their a way to find out - when
> > was the last
> > > > time a restore was performed for a particular TSM node.
> > > > 
> > > > 
> > > > 
> > > > Regards,
> > > > 
> > > > 
> > > > 
> > > > Kamran H. Rao
> > > > 
> > 

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