Select command for nodes not contacting more than a month

[akilap]

Hi ,

Wishes.. I wanted to know the select command which will list out the tsm nodes that were not contacting the tsm server for the past one month.

also if possible i wanted to know whether above such nodes is associated to any TSM schedules.

Thanks in advance.

 

[coolpapaj]

Here's part one. I'll see what I can do for part two.

SELECT NODE_NAME AS "Node Name:", DATE(LASTACC_TIME) AS "Last Access:" FROM NODES WHERE CAST((CURRENT_TIMESTAMP-LASTACC_TIME)DAYS AS DECIMAL(3,0))>30

 

[akilap]

Hi ,,
Many thanks for your command, its working.. have a great day..

 

[whitepup]

To check to see if any of the nodes are associated with a schedule you will have to run a separate command. I don't think join commands work with TSM's database.

select node_name,schedule_name from associations where node_name='YOUR_NODENAME'

YOUR_NODENAME is case sensitive.

 

[SleeperGTP]

Here is the second part:

select node_name from nodes where not node_name in (select node_name from associations)