Hi,

I like to report missed files filtered by domain using an modified query
from operational reporter.

Original query example:

select nodename,substr(char(date_time), 1, 16) as "TME",message from
actlog where (msgno=4005 or msgno=4007 or msgno=4018 or msgno=4037 or
msgno=4987) and (date_time between '2007-05-21 07:43:25' and '2007-05-22
07:43:24') order by nodename


After playing around with that query I have 2 problems:

1) inserting into the where part:
"and nodename in (select nodename from nodes where domain_name='MAC') "
gives an error of an not allowed outer query

(working with explicit node_names works, but isn't ideal)


2) since the original query above works with date strings I have to
substitute that part with something like that being using in q actlog
begind=-24:00 ...


Do you have any ideas to solve that 2 problems?