select statement possible?
2005-05-03 07:45:47
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
joni.moyer AT highmark DOT com
********************************
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- select statement possible?,
Joni Moyer <=
|
|
|