SQL for Tivoli Storage Manager
SQL for Tivoli Storage Manager Useful SQL Statements for TSM 10/26/2012 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. If you have any selects to share or have any comments, please contact me at <thobias (a) thobias org> Database and Recovery Log List all information from db table TSM database utilization (%) TSM log recovery utilization (%) Selecting specific columns from db table Number of database volumes not synchronized Number of log volumes not synchronized Nodes Number of nodes Number of nodes per domain Number of nodes per platform Nodes locked Number of nodes locked Number of nodes sessions TSM clients version List of nodes that have not accessed the tsm server in the last 90 days Filespaces List filespaces that have not been backed up in the last 365 days Occup...