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:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 7:22 AM
To: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 08/18/2002 08:14:58
PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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.
**********************************************************************
