try a combination of both

        select * from adsm.backups where ll_name='yourfile.name'
and
        select * from adsm.archives where ll_name='yourfile.name'
if it finds it, you'll have the node name, drive/filesystem, and directory
path to it...
this will take a while !

Dwight E. Cook
Software Application Engineer III
Science Applications International Corporation
509 S. Boston Ave.  Suite 220
Tulsa, Oklahoma 74103-4606
Office (918) 732-7109



-----Original Message-----
From: Jim Healy [mailto:James.Healy AT AXA-TECH DOT COM]
Sent: Monday, August 19, 2002 7:22 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: file search in DB


Can anyone tell me if there is a way to search the TSM database and find a
specific file and what server it existed on?
I have some legal requirements to restore a file and my admins don't know
what  server it was on.




"Zlatko Krastev" <acit AT ATTGLOBAL DOT NET>@VM.MARIST.EDU> on 08/18/2002 
08:14:58
PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:  Re: Select statement question


Henk,

in most cases your select will product good enough results. But if a shop
have many sessions with small ammounts of data to backup (RDBMS logs or
workstations for example) your query results might become inaccurate.
Instead of "select sum(cast(bytes/1024/1024/1024 as decimal))" use "select
cast(sum(bytes)/1024/1024/1024 as decimal)".

Zlatko Krastev
IT Consultant




Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:        Re: Select statement question

Wayne,

> Can anyone help me with a select query that will tell me how much data
I've
> backed up in the last 24 hours?

select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup" -
from summary where start_time>=current_timestamp - 1 day and
activity='BACKUP'

Cheers,
Henk ten Have





**********************************************************************

Confidentiality Note:  This e-mail is intended only for the
person or entity to which it is addressed and may contain
information that is privileged, confidential or otherwise
protected from disclosure.  Dissemination, distribution
or copying of this e-mail or the information herein by
anyone other than the intended recipient, or an employee
or agent responsible for delivering the message to the
intended recipient, is prohibited.  If you have received
this e-mail in error, please contact the sender and destroy
the original message and all copies.

**********************************************************************