Index: /tags/ipp-pv3-20140717/ippTools/share/remotetool_doneprep.sql
===================================================================
--- /tags/ipp-pv3-20140717/ippTools/share/remotetool_doneprep.sql	(revision 37294)
+++ /tags/ipp-pv3-20140717/ippTools/share/remotetool_doneprep.sql	(revision 37294)
@@ -0,0 +1,30 @@
+SELECT * FROM
+ (SELECT
+ remote_id,
+ remoteRun.path_base,
+ stage,
+ count(stage_id) as Ndone
+FROM remoteRun
+JOIN remoteComponent
+USING (remote_id)
+WHERE
+((remoteComponent.state = 'prep_done') OR (remoteComponent.state = 'prep_fail'))
+-- and hook %s
+GROUP BY remote_id)
+AS DONE
+
+JOIN
+
+(SELECT
+remote_id,
+count(stage_id) as Njobs
+FROM remoteRun
+JOIN remoteComponent
+USING (remote_id)
+-- where hook %s
+GROUP BY remote_id)
+AS JOBS
+
+using (remote_id)
+
+where Ndone = Njobs
Index: /tags/ipp-pv3-20140717/ippTools/share/remotetool_listcomponent.sql
===================================================================
--- /tags/ipp-pv3-20140717/ippTools/share/remotetool_listcomponent.sql	(revision 37294)
+++ /tags/ipp-pv3-20140717/ippTools/share/remotetool_listcomponent.sql	(revision 37294)
@@ -0,0 +1,11 @@
+SELECT DISTINCT
+    remoteComponent.remote_id,
+    remoteComponent.stage_id,
+    remoteComponent.jobs,
+    remoteComponent.state,
+    remoteComponent.path_base,
+    remoteRun.stage,
+    remoteRun.path_base as run_path_base
+FROM remoteRun
+JOIN remoteComponent
+    USING(remote_id)