Hello All!

I would like to create a report of all nodes and their respective schedules
within the windows domain.  I know that this will require a join between
the associations table and the client_schedules table, but I am unsure of
how to accomplish this task.

I know that a statement to get the client schedules info. would be select
domain_name,schedule_name,starttime,dayofweek from client_schedules where
domain_name='WINDOWS'
and the select statement for the associations info. would be select
domain_name,schedule_name,node_name from associations where
domain_name='WINDOWS'

Any help is appreciated.  Thanks!

********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
[EMAIL PROTECTED]
********************************

Reply via email to