Some information about backup copy group.Some information about archive copy group.Destination pool of each management class (type: backup copy group).Destination pool of each management class (type: archive copy group).Management classes with archive copy group information.Management classes with backup copy group information.Management classes of policy set ACTIVE that a specific node can use.Management classes of a specifc domain of policy set ACTIVE.Default management class per domain of policy set ACTIVE.Management classes per domain of policy set ACTIVE.
Number of drives not online in library 3584.Some cool information about node, associations and schedules.Information about schedules and associations (2 tables).Number of nodes associated per schedules.Number of nodes without associated schedules.Space stored and number of files per node, per storage pool and per type.Space stored and number of files per storage pool and per type (Archive/Backup).Space stored and number of files per storage pool.Storage space used per filespace and per backup/archive type for a specific node.Storage space used per filespace and per storage pool for a specific node.Storage space used per filespace for a specific node.Data stored per client and some information from nodes table.Space and number of files stored per client.List filespaces that have not been backed up in the last 365 days.Some nodes information and amount of space (from auditocc).List of nodes that have not accessed the tsm server in the last 90 days.Number of database volumes not synchronized.Selecting specific columns from db table.If you have any selects to share or have any comments, Here you can find out a lot of selects that will help you to get information from TSMĪnd to construct your own SQL statements. This page has a collection of useful SQL statements for IBM Tivoli Storage Manager (TSM). It will be kept for historical purpose only. If you have any select statements to share, I've decided to move this page to github. SQL for Tivoli Storage Manager SQL for Tivoli Storage Manager Useful SQL Statements for TSM
0 kommentar(er)
