On Feb 21, 2005, at 8:57 AM, Pretorius Louw <[EMAIL PROTECTED]> wrote:
We are in the process of implementing TSM campus-wide and we require more/better reporting than is currently available to us. I don't know sql queries, are there any pre-scripted queries somewhere that I can modify to suit our needs?
Your server Quick Start manual describes the installation of a suite of sample scripts which are shipped with the TSM server (scripts.smp file). Numerous examples of good queries can be found in the List archives. There is also http://www.coderelief.com/depot.htm .
Don't overlook the accounting records as a solid source of data for periodic reporting. I provide a sample report program at http://people.bu.edu/rbs/ .
Richard Sims