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
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
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)
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'