This works better, one can also fine tune this query for any particular node via adding a AND statement, e.x: AND ENTITY='Node_Name'.
This raises another question, how can one find out of "How long TSM maintains the SUMMARY Table" - I have a feeling that it is for 30 days as default. Does any one knows for sure? What I am really trying to do here is to find out the restores performed on a particular node for the past 1 year. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ribeiro, Ricardo Sent: Monday, November 12, 2007 10:26 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. 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 > > > >
