You can check out http://www.robertstinnett.com/control-m-resources/helpful-sql-queries-for-control-m/ where I have some SQL code snippets that can help with the ok/not ok reports.
Also, the reporting tool can give you this as well if you want to go that route.
url link gone. Where can i find the other source ?
Why don't you check in Control-M Webinars, I remember their is one which explains the way to take the report.