ADSM-L

Re: Query Node Wishlist

1998-12-22 18:02:55
Subject: Re: Query Node Wishlist
From: Russell Street <russells AT AUCKLAND.AC DOT NZ>
Date: Wed, 23 Dec 1998 12:02:55 +1300
> 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
<Prev in Thread] Current Thread [Next in Thread>