nodes not associated with any sched

[rogwall]

I want to find out if there is any node on TSM server that is not assiciated with any shcedule(s)., so that I could remove it (everything is through TSM schedule) Which select statement should give me this? Please suggest.



thanks,



:-o

 

[crazymad]

Hi, you are probably looking for something like this:

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



Hope it helps..

 

[rogwall]

perfect!!

thx