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. **********************************************************************
