Index: /trunk/ippScripts/scripts/night_report.pl
===================================================================
--- /trunk/ippScripts/scripts/night_report.pl	(revision 40834)
+++ /trunk/ippScripts/scripts/night_report.pl	(revision 40835)
@@ -140,5 +140,4 @@
     $summitPending = 0;
 
-#   my $query = "SELECT exp_name, exp_type, fault, state, count(*)";
     my $query = "SELECT exp_type, fault, state, count(*)";
     $query .= " FROM summitExp";
@@ -149,7 +148,4 @@
     $query .= " GROUP BY exp_type, fault, state";
 
-#    print "$query\n";
-#    die;
-
     my $result = &mysql_select ($query);
 
@@ -164,5 +160,22 @@
 	}
     }
-    if ($summitSkipped || $summitPending) { print "*** WARNING: $summitSkipped skipped rawExp, $summitPending incomplete rawExp ***\n\n"; } else { if ($verbose) { print "\n"; }}
+    if ($summitSkipped || $summitPending) { 
+        print "*** WARNING: $summitSkipped skipped rawExp, $summitPending incomplete rawExp ***\n\n"; 
+
+        my $query = "SELECT summitExp.exp_name,exp_type, fault, state";
+        $query .= " FROM summitExp";
+        $query .= " LEFT JOIN pzDownloadExp USING (summit_id)";
+        $query .= " WHERE dateobs like '$date%'";
+        $query .= " AND (state like 'new' or state IS NULL)";
+        $query .= " AND fault != 1042";
+
+        my $result = &mysql_select ($query);
+        printf "%12s %8s %15s %6s\n", "exp_name", "exp_type", "fault", "state"; 
+        while (@row = $result->fetchrow_array()) {
+            if ($row[3] eq "") { $row[3] = "NULL"; }
+	    printf "%12s %8s %15s %6s\n", $row[0], $row[1], $row[2], $row[3]; 
+        }
+    }
+    print "\n";
 }
 
