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
dlhuillier AT pershing DOT com
Enterprise Storage Forms ->
http://admpwb01/misc/misc/storage_forms_main.html



                    Dylan Ryback
                    <dryback@HOME        To:     ADSM-L AT VM.MARIST DOT EDU
                    .COM>                cc:
                    Sent by:             Subject:     What qualifies as an in 
use license?
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    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