Index: branches/haf_branches/ipp.20100512/ippTools/share/Makefile.am
===================================================================
--- branches/haf_branches/ipp.20100512/ippTools/share/Makefile.am	(revision 28058)
+++ branches/haf_branches/ipp.20100512/ippTools/share/Makefile.am	(revision 28102)
@@ -4,4 +4,5 @@
 
 dist_pkgdata_DATA = \
+     addtool_checkminidvodbaddrun.sql \
      addtool_donecleanup.sql \
      addtool_find_cam_id.sql \
@@ -11,5 +12,4 @@
      addtool_find_minidvodbprocessed.sql \
      addtool_find_minidvodbrun.sql \
-     addtool_find_minidvodbrun2.sql \
      addtool_pendingcleanupexp.sql \
      addtool_pendingcleanuprun.sql \
Index: branches/haf_branches/ipp.20100512/ippTools/share/addtool_checkminidvodbaddrun.sql
===================================================================
--- branches/haf_branches/ipp.20100512/ippTools/share/addtool_checkminidvodbaddrun.sql	(revision 28102)
+++ branches/haf_branches/ipp.20100512/ippTools/share/addtool_checkminidvodbaddrun.sql	(revision 28102)
@@ -0,0 +1,20 @@
+-- this selects the minidvodbs that have complete addRuns
+SELECT minidvodb_id, minidvodb_name, minidvodb_path, mergedvodb_path, state, minidbg 
+AS minidvodb_group, (cnt - cnt2) as not_full
+FROM minidvodbRun 
+JOIN 
+   (SELECT minidvodb_name, count(state) as cnt2, cnt, minidbg, minidbn 
+   FROM addRun LEFT JOIN 
+       -- this select grabs (and counts) all the addRuns with any state
+       -- and groups them by the name
+       (SELECT minidvodb_group as minidbg, minidvodb_name as minidbn, count(state) 
+        AS cnt 
+        FROM addRun 
+        GROUP BY minidvodb_name ) 
+   AS foo1 ON minidvodb_name = minidbn
+        -- the second select grabs and counts all the addRuns with state
+        -- of 'full'         
+   WHERE addRun.state = 'full' 
+   GROUP BY minidvodb_name ) 
+AS foo2 
+USING(minidvodb_name)