[ADSM-L] Help with SQL to Pull Information from TSM server

Hello everyone,

I am using  an SQL statement to query against TSM server, but I am not
able to pull any information.

This stat information is from TSM server created by TSM client performing
"dsmc backup delete".


06/13/2008 17:29:16      ANE4957I (Session: 23620, Node: SUNG)  Total
number
                          of objects deleted:        523(SESSION: 23620)
06/13/2008 17:29:16      ANE4959I (Session: 23620, Node: SUNG)  Total
number
                          of objects failed:           0(SESSION: 23620)
06/13/2008 17:29:16      ANE4961I (Session: 23620, Node: SUNG)  Total
number
                          of bytes transferred:     0  B(SESSION: 23620)
06/13/2008 17:29:16      ANE4963I (Session: 23620, Node: SUNG)  Data
transfer
                          time:                    0.00 sec(SESSION:
23620)
06/13/2008 17:29:16      ANE4966I (Session: 23620, Node: SUNG)  Network
data
                          transfer rate:            0.00 KB/sec(SESSION:
23620)
06/13/2008 17:29:16      ANE4967I (Session: 23620, Node: SUNG)  Aggregate
                          data transfer rate:          0.00
KB/sec(SESSION: 23620)
06/13/2008 17:29:16      ANE4968I (Session: 23620, Node: SUNG)  Objects
                          compressed by:                    0%(SESSION:
23620)
06/13/2008 17:29:16      ANE4964I (Session: 23620, Node: SUNG)  Elapsed
                          processing time:            00:00:14(SESSION:
23620)v

I tried to use this SQL attempting to pull this information with no luck.
Summary table does not appear to have "objects deleted" field nor any of
stat above.  What table can I query from?  Weird

select entity as node_name, date(start_time) as date, cast(activity as
varchar(10)) as activity, -
time(start_time) as start,time(end_time) as end, -
cast(substr(cast(end_time-start_time as char(20)),3,8) as char(8)) as
Length,-
cast(bytes/1024/1024/1024 as decimal(6,2)) as Gigabytes, -
cast(examined as decimal(15,0)) as files_examined, -
cast(FAILED as decimal(15,0)) as files_FAILED, -
cast(affected as decimal(15,0)) as files_backed, successful from summary
where -
start_time>=current_timestamp - 4 day  and entity='SUNG' -
order by successful, node_name


Thanks,

Sung Y.  Lee
Email:  sung.lee AT wachovia DOT com