Found this web page that has sample queries for TSM.

This page has a collection of useful SQL statements for IBM Tivoli Storage Manager (TSM). Here you can find out a lot of selects that will help you to get information from TSM and to construct your own SQL statements.

SQL for Tivoli Storage Manager

 I was looking for a way to get some information out of the TSM Database to use in a reporting project and came across this:

Introduction

This tutorial is intended to help with the first steps into working directly with the TSM database for the SQL illiterate administrator. We give a brief overview of the table structure and introduce some basic queries that might be helpful in the day to day administration.
Check out the Advanced Tutorial for more complex queries.

General Storage