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?