Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 24008)
+++ trunk/ippTools/share/Makefile.am	(revision 24038)
@@ -179,4 +179,5 @@
      receivetool_pendingfile.sql \
      receivetool_revert.sql \
+     receivetool_toadvance.sql \
      regtool_create_dup_table.sql \
      regtool_export_exp.sql \
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 24008)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 24038)
@@ -1315,4 +1315,7 @@
     comment VARCHAR(255),       -- for human memory
     fileset_last VARCHAR(128),  -- last fileset seen
+    status_product VARCHAR(64), -- status data store product
+    ds_dbname VARCHAR(64),      -- status data store's database name
+    ds_dbhost VARCHAR(64),      -- status data store's host name
     PRIMARY KEY(source_id),
     KEY(source),
@@ -1326,4 +1329,7 @@
     source_id BIGINT NOT NULL,  -- link to receiveSource
     fileset VARCHAR(128) NOT NULL, -- fileset to receive
+    state VARCHAR(64), -- new or full
+    dbinfo_uri VARCHAR(255), -- uri for database dump for this fileset's run
+    fault SMALLINT NOT NULL DEFAULT 0, -- Fault code
     PRIMARY KEY(fileset_id),
     KEY(source_id),
Index: trunk/ippTools/share/receivetool_pendingfile.sql
===================================================================
--- trunk/ippTools/share/receivetool_pendingfile.sql	(revision 24008)
+++ trunk/ippTools/share/receivetool_pendingfile.sql	(revision 24038)
@@ -5,4 +5,5 @@
     workdir,
     fileset,
+    fileset_id,
     file
 FROM receiveFile
Index: trunk/ippTools/share/receivetool_toadvance.sql
===================================================================
--- trunk/ippTools/share/receivetool_toadvance.sql	(revision 24038)
+++ trunk/ippTools/share/receivetool_toadvance.sql	(revision 24038)
@@ -0,0 +1,15 @@
+SELECT
+    receiveFileset.fileset_id,
+    receiveFileset.fileset,
+    receiveFileset.dbinfo_uri,
+    receiveSource.status_product,
+    receiveSource.ds_dbname,
+    receiveSource.ds_dbhost
+FROM receiveFileset 
+    JOIN receiveSource USING(source_id)
+    JOIN receiveFile USING(fileset_id)
+    JOIN receiveResult USING(file_id)
+WHERE receiveFileset.state = 'new' 
+    AND receiveFileset.fault = 0
+GROUP BY fileset_id 
+HAVING COUNT(receiveFile.file_id) = COUNT(receiveResult.file_id)