Andy,
        As usual, your insight is appreciated. That is one heck of a
select command... I'll have to toy with it in our test environment. Also
thanks for the info about the file ownership being in "blobs".

Thanks,
Ben 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Andrew Raibeck
Sent: Thursday, March 03, 2005 12:47 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Odd restores of old files....

1. True, there is no built-in functionality in TSM to make this easy.
You could try using the QUERY BACKUP client command with the -INACTIVE
option or the SELECT admin command to display all of User x's backups,
redirect the output to a file, and massage into individual restore
commands with corresponding -TODATE, -TOTIME, and -LATEST options (dsmc
restore c:\filea
c:\restdata\filea_20050302221015 -todate=03/02/2005 -totime=22:10:15
-latest).

This is really ugly, and I have not idea how well it will run in a real
TSM environment, but it was interesting to contemplate   :-)

select 'restore ' || '"' || filespace_name || hl_name || ll_name || '"
"'
|| \
       filespace_name || hl_name || ll_name || '_' || \
       left(cast(date(backup_date) as char(10)), 4) || \
       substr(cast(date(backup_date) as char(10)), 6, 2) || \
       right(cast(date(backup_date) as char(10)), 2) || '_' || \
       left(cast(time(backup_date) as char(8)), 2) || \
       substr(cast(time(backup_date) as char(8)), 4, 2) || \
       right(cast(time(backup_date) as char(8)), 2) || \
       ' -todate=' || \
       substr(cast(date(backup_date) as char(10)), 6, 2) || '/' || \
       right(cast(date(backup_date) as char(10)), 2) || '/' || \
       left(cast(date(backup_date) as char(10)), 4) || \
       ' -totime=' || \
       left(cast(time(backup_date) as char(8)), 8) || \
       ' -latest' \
   from backups

Best run as a macro in batch mode with the -commad and -dataonly=y
options.

2. There are no server commands that will give you the owner info. The
TSM server houses the data as a "blob", but has knowledge of how to
interpret it.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew
Raibeck/Tucson/IBM@IBMUS Internet e-mail: storman AT us.ibm DOT com

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 2005-03-02
12:21:10:

>    ~Gah~, I hate it when Legal calls up on a "fishing trip"...
>
> Here are their questions:
>
> 1.
>    "Can we restore all the deleted files/versions of from UserX's home

> directory so we can look at them?"
>
>    My initial thoughts: Not too bad, but how can I deal with all the 
> different versions of a file? There's no TSM built-in way to restore 
> them all with different names unless I do it manually.
>
> 2.
>    "Can we restore all of UserX's deleted files from all the backups 
> across the enterprise?"
>
>    My initial thoughts: WHAT?!?! We have 800 TSM clients with 400TB of

> backed up data in 600 million files!
>    In our environment users have many areas they can write to: Home 
> directories, Departmental servers, Source-code repositories, 
> production areas, etc. How the heck can I find all of a users files in

> the TSM backups? There are no queries that I can see that show file 
> owners, even though I know it is in the TSM DB somewhere. I might be 
> able to get ownership by running one of those undocumented "show" 
> commands but I'm still not sure it would work.
>
>
>    What do you all think?
>
>    I think #1 is possible but unfortunately a manual process, #2 is 
> way out there near the "impossible" realm.
>
> Thanks,
> Ben