Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 28853)
+++ trunk/ippTools/share/Makefile.am	(revision 28856)
@@ -6,4 +6,5 @@
 	addtool_checkminidvodbaddrun.sql \
 	addtool_donecleanup.sql \
+	addtool_find_cam_id_dvo.sql \
 	addtool_find_cam_id.sql \
 	addtool_find_pendingexp.sql \
Index: trunk/ippTools/share/addtool_find_cam_id_dvo.sql
===================================================================
--- trunk/ippTools/share/addtool_find_cam_id_dvo.sql	(revision 28856)
+++ trunk/ippTools/share/addtool_find_cam_id_dvo.sql	(revision 28856)
@@ -0,0 +1,10 @@
+SELECT camRun.* FROM camRun
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
+WHERE camRun.state = 'full'
+    AND exp_id NOT IN (SELECT exp_id
+       FROM addRun
+       JOIN camRun USING(cam_id)
+       JOIN chipRun USING(chip_id)
+       WHERE %s
+      )