Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 24239)
+++ trunk/ippTools/share/Makefile.am	(revision 24284)
@@ -154,8 +154,10 @@
      magictool_rawimfile.sql \
      magictool_revertnode.sql \
+     magicdstool_completed_runs.sql \
+     magicdstool_getrunids.sql \
+     magicdstool_getskycells.sql \
      magicdstool_todestreak.sql \
-     magicdstool_completed_runs.sql \
-     magicdstool_getskycells.sql \
-     magicdstool_getrunids.sql \
+     magicdstool_toremove.sql \
+     magicdstool_torestore.sql \
      pstamptool_addjob_otherjob.sql \
      pstamptool_addjob_stampjob.sql \
Index: trunk/ippTools/share/magicdstool_toremove.sql
===================================================================
--- trunk/ippTools/share/magicdstool_toremove.sql	(revision 24284)
+++ trunk/ippTools/share/magicdstool_toremove.sql	(revision 24284)
@@ -0,0 +1,11 @@
+SELECT 
+    magic_ds_id,
+    stage,
+    stage_id,
+    component,
+    backup_path_base
+FROM magicDSFile
+JOIN magicDSRun USING(magic_ds_id)
+WHERE magicDSRun.remove
+    AND magicDSRun.state = 'full'
+    AND backup_path_base IS NOT NULL
Index: trunk/ippTools/share/magicdstool_torestore.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torestore.sql	(revision 24284)
+++ trunk/ippTools/share/magicdstool_torestore.sql	(revision 24284)
@@ -0,0 +1,12 @@
+SELECT 
+    magic_ds_id,
+    stage,
+    stage_id
+    component,
+    backup_path_base,
+    recovery_path_base
+FROM magicDSFile
+JOIN magicDSRun USING(magic_ds_id)
+WHERE magicDSRun.state = 'goto_restored'
+    AND backup_path_base IS NOT NULL
+    AND recovery_path_base IS NOT NULL