Hi,
    You can use below select statement to view the full db backup details.

   SELECT DATE_TIME AS "DATE TIME",TYPE,BACKUP_SERIES,VOLUME_NAME FROM
VOLHISTORY WHERE TYPE='BACKUPFULL'

        REPLACE 'BACKUPFULL' WITH 'BACKUPINCR' IF YOU TAKE INCREMENTAL
BACKUP

With Best Regards,
Sandeep Jain
 
 
 
********************** Legal Disclaimer
****************************************************************************
******

"This email may contain confidential and privileged material for the sole
use of the intended recipient. Any unauthorized review, use or distribution
by others is strictly prohibited. If you have received the message in error,
please advise the sender by reply email and delete the message. Thank you." 

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

 


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Roger Silva
Sent: Thursday, May 25, 2006 1:54 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select Statements


Hi,

I am new to the this list and need some advice.

I am trying to create a select statement I can run to monitor the Database
Backups of our TSM Servers.  I know there are fields in the SUMMARY portion
of the table that has Start Time, End Time, Activity, Entity, Volume Name
and Successful fields, but I am not sure as to how to put all this together
in a nice script that can email to a group of
individuals the status.   I am not sure if I need to query several
parts of the database in order to compile this info or not.

Can anyone help me out?

Thank You,
Roger



This email has been scanned for any virus infection at the sending end.