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.

Robert