Index: trunk/pstamp/scripts/psstatus
===================================================================
--- trunk/pstamp/scripts/psstatus	(revision 30483)
+++ trunk/pstamp/scripts/psstatus	(revision 30517)
@@ -13,6 +13,6 @@
 my $running;
 my $finished;
-my $req_faulted;
-my $job_faulted;
+my $finishing;
+my $totals;
 my $dbname;
 my $dbserver;
@@ -20,5 +20,4 @@
 my $dbpassword;
 my $verbose;
-my $finishing;
 
 GetOptions(
@@ -26,6 +25,5 @@
     'finished|f',    \$finished,
     'finishing',     \$finishing,
-    'req_faulted',   \$req_faulted,
-    'job_faulted',   \$job_faulted,
+    'totals|t',      \$totals,
     'limit|l=i',     \$limit,
     'dbname=s',      \$dbname,
@@ -35,7 +33,7 @@
 pod2usage( -msg => "Unknown option: @ARGV", -exitval => 2 ) if @ARGV ;
 
-$running = 1 if (!$finished and !$finishing and !$running);
-
-my $no_args = ! (defined $running or defined $finished or defined $req_faulted or defined $job_faulted );
+$running = 1 if (!$finished and !$finishing and !$running and !$totals);
+
+my $no_args = ! (defined $running or defined $finished or defined $finishing or defined $totals );
 
 die "cannot supply --running and --finished\n" if ($running and $finished);
@@ -44,4 +42,11 @@
 my $ipprc =  PS::IPP::Config->new();
 my $dbh = getDBHandle();
+
+my $totals_query = "
+SELECT label, count(job_id) AS 'Unfinished Jobs', priority
+FROM pstampRequest join pstampJob USING(req_id)
+JOIN Label USING(label)
+WHERE pstampJob.state ='run' and pstampRequest.state ='run'
+GROUP by label";
 
 my $running_query = "
@@ -51,5 +56,5 @@
     label,
     reqType,
-    priority,
+   -- priority,
     state,
     fault,
@@ -233,5 +238,7 @@
 
 my $sql;
-if ($finished) {
+if ($totals) {
+    $sql = $totals_query;
+} elsif ($finished) {
     $sql = $finished_query;
 } elsif ($running) {