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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> 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:[EMAIL PROTECTED] On > Behalf Of Kamran Rao > Sent: Monday, November 12, 2007 8:25 AM > To: [email protected] > 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:[EMAIL PROTECTED] On > Behalf Of CAYE PIERRE > Sent: Monday, November 12, 2007 10:23 AM > To: [email protected] > 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:[EMAIL PROTECTED] De la part > > de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À : > > [email protected] 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/[EMAIL PROTECTED] Internet > > e-mail: [EMAIL PROTECTED] > > > > 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" <[email protected]> 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:[EMAIL PROTECTED] > > On Behalf > > > Of CAYE PIERRE > > > Sent: Monday, November 12, 2007 4:07 AM > > > To: [email protected] > > > 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:[EMAIL PROTECTED] De la > > > > part de Kamran Rao Envoyé : vendredi 9 novembre 2007 21:12 À : > > > > [email protected] 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 > > > > > >
