Examples: query tsm command

The query tsm command displays information about the IBM Storage Protectâ„¢ API and IBM Storage Protect server.

The following example includes output from the tdpexcc query tsm command:
IBM Tivoli Storage Manager for Mail:
Data Protection for Microsoft Exchange Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015. All rights reserved.

Tivoli Storage Manager Server Connection Information
----------------------------------------------------

Nodename ............................... MALTA_EXC
NetWork Host Name of Server ............ GIJOE
TSM API Version ........................ Version 7, Release 1, Level 2.0

Server Name ............................ GIJOE_SERVER1_230
Server Type ............................ Windows
Server Version ......................... Version 7, Release 1, Level 2.0
Compression Mode ....................... Client Determined
Domain Name ............................ FCM_PDEXC
Active Policy Set ...................... STANDARD
Default Management Class ............... STANDARD

Completed
For backups that are created from an Exchange Server Database Availability Group (DAG) member, both the DAG node name and the name of the server on which that backup was run are displayed with the query tsm command. The following example queries the IBM Storage Protect server for the backup objects that were backed up under the DAG node name DAG2 from DAG member server TIVVM483:
Command:
tdpexcc query tsm *
Output:
IBM Tivoli Storage Manager for Mail:
Data Protection for Microsoft Exchange Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015. All rights reserved.

Querying Tivoli Storage Manager server for a list of database backups, please wa
it...

Connecting to TSM Server as node 'TIVVM483_EXC'...
Connecting to Local DSM Agent 'TIVVM483'...
Using backup node 'DAG2'...

  DAG              : DAG2

  Database         : RATTEST_DAGDB

     Backup Date        Size     S Fmt  Type   Loc        Object Name
-------------------  ----------- - ---- ----   --- -------------------------
03/27/2014 16:11:14     149.07MB A VSS  full   Srv 20140327161114

                         13.01MB                   Logs
                        136.06MB                   File
03/27/2014 18:02:01      14.00MB A VSS  incr   Srv 20140327180201
                         14.00MB                   Logs

The following example queries the IBM Storage Protect server in detail for the backup objects that were backed up under the DAG node name DAG2 from DAG member server TIVVM483:

Command:
tdpexcc query tsm * /detail
Output:
IBM Tivoli Storage Manager for Mail:
Data Protection for Microsoft Exchange Server
Version 7, Release 1, Level 3.0
(C) Copyright IBM Corporation 1998, 2015. All rights reserved.

Querying Tivoli Storage Manager server for a list of database backups, please wa
it...

Connecting to TSM Server as node 'TIVVM483_EXC'...
Connecting to Local DSM Agent 'TIVVM483'...
Using backup node 'DAG2'...

Backup Object Information
-------------------------

Exchange Server Name ..................... TIVVM483
Database Availability Group .............. DAG2
Backup Database Name ..................... RATTEST_DAGDB
Backup Method ............................ VSS
Backup Location .......................... Srv
Backup Object Type ....................... full
Mounted as ...............................
Backup Object State ...................... Active
Backup Creation Date / Time .............. 03/27/2014 16:11:14
Backup Compressed ........................ No
Backup Encryption Type ................... None
Backup Client-deduplicated ............... No
Backup Supports Instant Restore .......... No
Backup Object Size / Name ................   149.07MB / 20140327161114 (From DBC
opy)
Backup Object Size / Name ................    13.01MB / Logs
Backup Object Size / Name ................   136.06MB / File