We hope these examples gave you an understandable introduction of how you can extract basic information from the TSM Database and would like to point your attention to the following sources:
First, check the TSM Help for more details about SQL and how it works in the TSM environment by typing "h select" on a TSM Admin command line. You'll find a bunch of useful examples for day to day business and pointers to related information like setting the various SQL format options in TSM.
Also checkout our more advanced samples in the "Code Bits" Section.
Take a look at the many SQL tutorials on the internet by simple searching for "sql tutorial" with your preferred Web search engine.
If you can't get at the info you want and prefer a more graphical approach to working with the TSM Database, download the Home Edition of ActView for a quick graphical overview about what happened when and why on your server.
For working through Gigabytes of info on a larger number of distributed TSM Servers, checkout General Storage ActView Enterprise Edition, a fully blown Replication, Data Mining and Monitoring Solution for TSM.