which nodes are not associated with any client schedule

[rogwall]

we have hundreds of nodes defined and dozens of client schedules,

I want to get rid of the nodes that are not scheduled (of course with proper change requests).



How can I generate list of nodes not associated?



thanks.

 

[heada]

If the nodes are set to prompt rather than polling, you could query for what nodes haven't talked to the TSM server in X days



select node_name,lastacc_time from nodes where -

cast((current_timestamp-lastacc_time)days as -

decimal) >= $1



($1 is the number of days)



Or, you can query for any nodes in a policy domain that are not a part of a schedule, like this:



select node_name from nodes where -

domain_name=upper('$1') and node_name not in -

(select node_name from associations where -

domain_name=upper('$1') and -

schedule_name=upper('$2'))



($1 is the domain and $2 is the schedule name)



-Aaron

 

[rogwall]

The 1st command is not right for me.



select node_name from nodes where domain_name=upper('CAPITAL_MARKETS') and node_name not in (select node_name from associations where domain_name=upper('CAPITAL_MARKETS') and schedule_name=upper('$2'))



which means this command will have to be run for each scheduler. 50 schedulers, 50 commands.

 

[reesema]

This is the query that I use:



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