Again, searching the actlog or the summary table for the restore information is fine as long as what you're looking for is within the retention of the ACTLOGRETENTION and SUMMARYRETENTION values you've set. Or if you're saving the actlog on a regular basis you can search it still. But if it's past those retention values, your kinda SOL. You can dig the information out of the accounting records, but again only if you have accounting on.
I'm not sure if some of the OEM monitoring packages (TSMManager, ServerGraph) capture and retain this information or not. Might be an option for you, too. Bill Boyer "My problem was caused my a loose screw at the keyboard" - ?? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rejean Larivee Sent: Thursday, November 15, 2007 9:02 AM To: [email protected] Subject: Re: Is their a way to find out - when was the last time a restore was performed for a TSM node. Hello, and if you want more granularity, you can also use the "REPORTRETRIEVE YES" server option. With this option, message ANR0411I will be logged in the TSM activity log when a file is restored. For example : <timestamp> ANR0411I Session 8 for administrator COLIND-TUC logged in as node COLIND-TUC restored or retrieved Backup object: node COLIND-TUC, filespace \\colind-tuc\c$, object\CODE\TESTDATA\ XXX.OUT Rejean Larivee IBM Tivoli Storage Manager support IBM Global Technology Services ********************************************************************************************************** Visit our new IBM Tivoli Storage Manager support page: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html Expand IBM Tivoli product knowledge through our Support Technical Exchange. http://www-306.ibm.com/software/sysmgmt/products/support/supp_tech_exch.html ********************************************************************************************************** "ADSM: Dist Stor Manager" <[email protected]> wrote on 11/12/2007 11:40:08 AM: > As long as the last restore was within the retention you've set for > the summary table. QUERY STATUS to find out the current valut. > SET SUMMARYRETENTION to set/change. > > Same as for a previous suggestion for querying the actlog. The restore > has to be within the ACTLOG retention value. > > Only long term retention of this data is in the accounting data (SET > ACCOUNTING ON). It doesn't say restore for the record, but you could > query that nodename and look at fields 18 and 19 for "retrieved backup > objects". > > Bill Boyer > "Nothing is foolproof to a sufficiently talented fool." - Murphy > > > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of Ribeiro, Ricardo > Sent: Monday, November 12, 2007 10:25 AM > To: [email protected] > Subject: Re: Is their a way to find out - when was the last time a > restore was performed for a TSM node. > > Just run this statement... > SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE' > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of CAYE PIERRE > Sent: Monday, November 12, 2007 8: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 > > > > > >=
