Hello List - My goal is to script a customized report in the Operational Reporting tool, to report backup information for selected nodes to specific email recipients (the nodes are differentiated by the node-contact field).
My problem is that a straight select on the EVENTS table is only pulling back results that occurred since midnight. Then, when I try to insert a WHERE clause (WHERE SCHEDULED_START >= CURRENT_TIMESTAMP - 24 HOURS), I get a RC=11 (no match). With trial & error, if I hard-code the previous day (WHERE SCHEDULED_START >= '2005-01-19 17:00'), I receive the results I'm looking for. But, I need this in script form with no hard-coding, since it will run automatically. I've also investigated the use of a Q EVENT * * clause, but I can't use it, because I can't key on the CONTACT field off the NODES table (I could hard-code the specific nodes, but that changes relatively often, so that's not a fool-proof method for my site). Does anyone have a solution to this problem, either through the use of a variable or a TIME field that will compare to the SCHEDULED_START field? Remember, it needs to be a straight SELECT statement that runs through the Operational Reporting tool. Thanks, in advance and have a happy Mardi Gras. David Moore State of Louisiana
