Quick cheats

Not really much happened since then. This is still valid, what you linked in your post.
As Mita201 mention, the link is still valid.
Unless you are needing some specific data, can learn a new skill.
Or use AI to generate the select statement.

SELECT (Perform an SQL query of the IBM Spectrum Protect database)

Here is a link to

Database Table Schema​

Can upload the database schema and have AI generate what you want.
Keep in mind, garbage in, garbage out.
You may have to adjust the select statement to work.

Attach is the schema for TSM V5 or v6.

Good Luck,


  • TSM Table Schema.zip
    513.9 KB · Views: 4