tsmuser10
ADSM.ORG Member
I haven't worked in TSM in some time since 2020 I'm looking for a good SQL cheat list like the old school one from 2016
Thanks
Thanks
-
-
Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
Quick cheats
- Thread starter tsmuser10
- Start date
Mita201
ADSM.ORG Senior Member
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
www.ibm.com
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,
Sias
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)
SELECT
Use the SELECT command to create and format a customized query of the IBM Spectrum Protect database.
www.ibm.com
Here is a link to
Database Table Schema
Database Table Schema
Attribute groups collect data for the IBM Spectrum Protect servers. The data is stored in the WAREHOUS database. To understand how to create custom reports, you must understand the data that is collected and stored in the database. The following tables show the attribute group, the corresponding...
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,
Sias
