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
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
> > > >
> >
|
|
|