Roger

I recently had to query the summary table for info regarding the
database backups. My requirement was to report how long the database
backups were taking. I found that the following select query sufficed.

select substr(char(end_time-start_time),3,8) as backup_duration from
summary where activity='FULL_DBBACKUP'

I know this is not exactly what you are asking, but from the construct,
you should be able alter it to do exactly the things you require.

Also, the following query will return all the fields that are available
for database backups in the summary table


select * from summary where activity='FULL_DBBACKUP'

HTH

Leigh




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Roger Silva
Sent: 24 May 2006 21:24
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