Windows IBM TSM 6.X client - View History of Restores

We have a Windows 2008 server that has the TSM 6.x client installed. The main TSM server running AIX. Is there a way from the Windows server to see what file / folders have been restored? I tried view the files in C:\program files\TSM\baclient and have not found anything helpful
LVL 21
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

The Backup/Archive client does not write a log, except for scheduled operations.

On the other hand, the TSM server does keep an activity log.

Start the admin client (dsmadmc) and run the following query:

select cast(START_TIME as DATE) DATE, cast(START_TIME as TIME) TIME, -
                     (END_TIME-START_TIME)minutes as "Elapsed(min)", -
             cast(ENTITY as char(18)) Entity, cast(AFFECTED as dec(7)) Files, -
             cast((BYTES/1024/1024) as dec(9,2)) MB -
         from summary -
             where ACTIVITY='RESTORE' and ENTITY like upper('clientname')

Replace clientname with the name by which your Windows box is known to TSM.

The query will show date, time and duration of the client's restore operations, as well as
the number of files and the number of megabytes restored.

Unfortunately, we don't have a way to find out which files have been restored by means of a database query. TSM does not keep track of single filenames in its summary log.

If the restore operation took place not too long ago you can try to investigate the activity log (also under "dsmadmc"):

q actlog begind=-99 node=CLIENTNAME

CLIENTNAME must be ALL UPPERCASE in this environment!

The latter command will take quite a lot of time, and I doubt that it will show something useful, but you should try.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
compdigit44Author Commented:
thank you very much!!!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.