Nodes not associated with a schedule.

[Tony_p]

I am looking for a way (Command)to display all nodes and what schedule they are associated with (TSM 5.3). I am trying to find a simple way to located nodes that are defined but not scheduled to backup.

Thanks!

 

[cheffern]

Try this - it'll just give you more info if you use the 'locked' and 'contacts' fields:

SELECT VARCHAR(node_name,20) as NODE, -
VARCHAR(locked,5) as LOCKED, -
VARCHAR(contact,100) as COMMENTS -
FROM nodes -
WHERE UPPER(node_name) NOT IN ( -
SELECT UPPER(node_name) -
FROM associations -
) -
and (locked=NO) -
GROUP BY node_name, -
locked, -
contact

(I use the Contacts field for info like why I took a box out of a schedule, etc...
just helpful for me )

-Chef.

 

[bbrown00]

Try this:

select node_name from nodes where node_name NOT IN (select node_name from associations)

Hopefully that helps

 

[Tony_p]

Yes that works very well!

 

[eperez507]

ANS8000I Server command: 'select node_name,platform_name from nodes where domain_name='STANDARD' and node_name not in (select node_name from associations where domain_name='STANDARD' ) and platform_name <> 'TDP Oracle AIX' and platform_name <> 'TSM4SBRa' and platform_name <> 'ICMRM' and platform_name <> 'TDP MSSQL Win32' and platform_name <> 'DartOS' and platform_name <> 'DB2/AIX64' and platform_name <> 'DB2/6000' and locked='NO' order by platform_name asc'