Latest HPSS Staging Failures for

900000 and logger = 'staging_failed'"; } if ($exp == 'phenix') { $query="select count(*) as ecount from log where log_index > 1500000 and logger = 'staging_failed'"; } if ($exp == 'phobos') { $query="select count(*) as ecount from log where log_index > 1200000 and logger = 'staging_failed'"; } if ($exp == 'star') { $query="select count(*) as ecount from log where log_index > 3900000 and logger = 'staging_failed'"; } $results = mysql_query($query) or die("Select Failed"); $record = mysql_fetch_array($results); $count = $record['ecount']; $lim = $count - 5; if ($exp == 'brahms') { $query="select date_format(timestamp,'%D %M %H:%m:%s %Y') as dd,message from log where log_index > 900000 and logger = 'staging_failed' limit $lim,50"; } if ($exp == 'phenix') { $query="select date_format(timestamp,'%D %M %H:%m:%s %Y') as dd,message from log where log_index > 1500000 and logger = 'staging_failed' limit $lim,50"; } if ($exp == 'phobos') { $query="select date_format(timestamp,'%D %M %H:%m:%s %Y') as dd,message from log where log_index > 1200000 and logger = 'staging_failed' limit $lim,50"; } if ($exp == 'star') { $query="select date_format(timestamp,'%D %M %H:%m:%s %Y') as dd,message from log where log_index > 3900000 and logger = 'staging_failed' limit $lim,50"; } $results = mysql_query($query) or die("Select Failed"); ?>

Date	Message