Index: trunk/ippTools/share/disttool_listfilesets.sql
===================================================================
--- trunk/ippTools/share/disttool_listfilesets.sql	(revision 26090)
+++ trunk/ippTools/share/disttool_listfilesets.sql	(revision 26090)
@@ -0,0 +1,14 @@
+SELECT
+    fs_id,
+    dist_id,
+    distRun.label,
+    rcDSFileset.state AS fileset_state,
+    rcDSFileset.name AS fileset,
+    rcDestination.name AS product,
+    rcDestination.dbname,
+    rcDestination.dbhost
+FROM rcDSFileset
+JOIN distRun USING(dist_id)
+JOIN distTarget USING(target_id, stage, clean)
+JOIN rcInterest USING(target_id, dest_id)
+JOIN rcDestination USING(dest_id)
Index: trunk/ippTools/share/disttool_pendingcleanup.sql
===================================================================
--- trunk/ippTools/share/disttool_pendingcleanup.sql	(revision 26090)
+++ trunk/ippTools/share/disttool_pendingcleanup.sql	(revision 26090)
@@ -0,0 +1,8 @@
+SELECT 
+    dist_id,
+    stage,
+    stage_id,
+    label,
+    outdir
+FROM distRun
+WHERE state = 'goto_cleaned'