All those things are in the SUMMARY table - try SELECT * FROM SUMMARY.
-----Original Message-----
From: Jeffery Carroll [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 3:07 PM
To: [EMAIL PROTECTED]
Subject: SQL Reporting
Running TSM 3.7.4 for NT
We are looking to put a report together that would show the results of the
previous nights incrementals. We are looking for the following info via
SQL reporting from TSM database. What we are looking for is the
following.
NodeName,Actual Start Time, Actual Completions Time, Amount of data
transferred per node, and Event Status (Complete,Missed,etc).
I found a couple of the needed tables, but still missing some of the above
information.
Any assistance appreciated.
Thanks,