Re: Query Node Wishlist
1998-12-22 18:02:55
> Wouldn't it be nice to see what schedule(s) a node is associated with by
> typing query node? Query Association is just too bulky when you want
> info on one node. Anyone else want that?
On a v3 server you can do something like:
select domain_name, schedule_name from associations where node_name = 'WHOEVER'
and if you join tables to get the nodename, domain, schedule and start time:
select -
associations.node_name, -
client_schedules.domain_name, -
client_schedules.schedule_name, -
client_schedules.starttime -
from -
associations, -
client_schedules -
where -
associations.node_name = 'WHATEVER' -
and associations.schedule_name = client_schedules.schedule_name -
and associations.domain_name = client_schedules.domain_name
Russell
|
|
|