Not sure on how the inuse is calculated but here's the sql: select node_name from nodes where node_name not in ( select node_name from associations )
Regards, Denis L. L'Huiller 973-360-7739 [EMAIL PROTECTED] Enterprise Storage Forms -> http://admpwb01/misc/misc/storage_forms_main.html Dylan Ryback <dryback@HOME To: [EMAIL PROTECTED] .COM> cc: Sent by: Subject: What qualifies as an in use license? "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] RIST.EDU> 01/15/2002 10:45 AM Please respond to "ADSM: Dist Stor Manager" I'm in the midst of doing a cleanup job on our TSM servers. When I do a 'q license', one of the results is: Number of Managed System for LAN in use: 107 My question is, what counts as 'in use'? For example, there are a bunch of nodes that are defined and are no longer used or associated with any schedules. Do these count as 'in use', and if so, should I export the node out of the db and delete it to get the license counts down? One other question: anyone got a query to figure out which nodes are NOT associated with a schedule. This would help me identify nodes that are candidates for export. Many thanks, Dylan
