Re: [ADSM-L] finding out if a node is associated with a schedule

ADSM-L

[Top] [All Lists]

Re: [ADSM-L] finding out if a node is associated with a schedule

2010-03-13 20:38:56

Subject:	Re: [ADSM-L] finding out if a node is associated with a schedule
From:	Skylar Thompson <skylar2 AT U.WASHINGTON DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Sat, 13 Mar 2010 17:37:30 -0800

This ought to do the trick:

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

yoda woya wrote:
> using sql, how do i find out the do nodes that are not associated with a
> schedule
>   

-- 
-- Skylar Thompson (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S048, (206)-685-7354
-- University of Washington School of Medicine

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
[ADSM-L] finding out if a node is associated with a schedule, yoda woya Re: [ADSM-L] finding out if a node is associated with a schedule, Skylar Thompson <= Re: [ADSM-L] finding out if a node is associated with a schedule, Laura Lantz Re: [ADSM-L] finding out if a node is associated with a schedule, Laura Lantz

Previous by Date:	[ADSM-L] finding out if a node is associated with a schedule, yoda woya
Next by Date:	[ADSM-L] assessing the health TSM installation, yoda woya
Previous by Thread:	[ADSM-L] finding out if a node is associated with a schedule, yoda woya
Next by Thread:	Re: [ADSM-L] finding out if a node is associated with a schedule, Laura Lantz
Indexes:	[Date] [Thread] [Top] [All Lists]