Thank You Sandeep,

I made changes since some of the fields didn't work for me, but this is
what I have:

SELECT DATE_TIME AS DATE,TYPE,VOLUME_NAME,LOCATION FROM VOLHISTORY
WHERE TYPE='BACKUPFULL'

But, what I would like to do is pull just the last or most current
BACKUPFULL or BACKUPINCR information.  I have been looking for some
sort of a "CURRENT TIMESTAMP" or something on those lines?

Is there something I can add to get this info?

Rog


On May 25, 2006, at 3:19 AM, Sandeep Jain wrote:

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.