query Scheduler Results and No Scheduler association

[tomk]

Hello,

is it possible to create a script which reports for the last day the status and result from the scheduler and also lists all nodes which have no associations or otherwise combine the following two select statements:

SELECT a.node_name, b.schedule_name, b.result, b.status FROM nodes a, events b WHERE a.node_name = b.node_name AND days(current_timestamp)-days(scheduled_start)=1
SELECT node_name FROM nodes WHERE node_name NOT IN (SELECT node_name FROM associations)

Thanks
tom