Querying Nodes, Events, Schedules and Sessions from the TSM Server

  • QUERY NODE – display the information about one or more registered nodes;
  • QUERY EVENT – display the status of scheduled events;
  • QUERY SCHEDULE – display information about one or more schedules;
  • QUERY SESSION – display information about node sessions.

Querying Nodes

Display the information on all registered client nodes:

tsm> query node

Display the information on the node named JOHN2013:

tsm> query node JOHN2013

Display complete information on the node named JOHN2013:

tsm> query node JOHN2013 format=detailed

Read more

Querying Events

Display the information for 10 days, for all events, scheduled on the node named JOHN2013:

tsm> query event * * begindate=-10 enddate=today node=JOHN2013

Display the complete information for 10 days:

tsm> query event * * begindate=-10 enddate=today format=detailed node=JOHN2013

Display the information, for all events, scheduled on the node named JOHN2013, during specific days:

tsm> query event * * begindate=01/15/2013 enddate=01/20/2013 node=JOHN2013

Read more

Querying Schedules

Display the information on all registered schedules:

tsm> query schedule

Display the information about schedule INCR_20H in domain STANDARD:

tsm> query schedule STANDARD INCR_20H

Display the complete information about schedule INCR_20H:

tsm> query schedule * INCR_20H format=detailed

Display associated schedules, for the node named JOHN2013:

tsm> query schedule node=JOHN2013

Display nodes associated with a schedule INCR_20H:

tsm> query association * INCR_20H

Display nodes without associated schedule:

tsm> SELECT node_name FROM nodes WHERE node_name NOT IN \ 
(SELECT node_name FROM associations)

Read more

Querying Sessions

Display the information on all current sessions:

tsm> query session

Display the information on sessions from a node named JOHN2013:

tsm> SELECT client_name,session_id,start_time,CAST(bytes_sent/1024/1024 \
AS DEC(8,2)) AS "MB_Sent", CAST(bytes_received/1024/1024 AS DEC(8,2)) \ 
AS "MB_Rcvd" FROM sessions WHERE client_name='JOHN2013'

Read more

Was it useful? Share this post with the world!

Leave a Reply