Hi Rene!
If you can't do it using SQL, why don't you use the admin commandline
interface with the command Q EVENT * * BEGINDATE=TODAY-1 ENDDATE=TODAY EX=Y
for failed and missed backup events and the command Q EVENT *
BEGINDATE=TODAY-1 ENDDATE=TODAY TYPE=ADMIN EX=Y for failed/missed
administrative commands.
Do not omit the ENDDATE parameter, you would expect ENDDATE=TODAY to be
default, but if you don't specify it, you will not see last nights failed
events...
Kindest regards,
Eric van Loon