First, querying the tables directly is not supported, better use the execution log views, see
Report Server ExecutionLog and the ExecutionLog3 View
But it gives you only the info, if an execution failed, for details you have to lookup error/trace files, see