Need a script to count NON dissociated windows clients

[tsmhelum]

Hi,

Does anyone have a script or know a command to count the number of windows nodes/clients left on a server that ARE NOT DISSOCIATED? we have dissociated a number of nodes and I would like to count the remaining clients left. However I don't want to include the dissociated clients that are still left on the TSM Server


Thanks for any help!

[moon-buddy]

Try this from (as a starting point) http://thobias.org/tsm/sql/index.html#toc24:

SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)