$pdf->SetTextColor(0, 0, 0); while ($query_row = mysql_fetch_assoc($query)) { $hostname = $query_row['server']; $environ = $query_row['environ']; $pdf->Cell(0, 10, 'Server: ' . $hostname . ' [' . $environ . ']', 0, 1, 'L'); } $cpuquerytot = mysql_query("SELECT date(date)as date,time(date) as time,user,nice,system,iowait,steal,idle from cpurep where date(date) = '{$dt}'"); if (mysql_num_rows($cpuquerytot)) { $pdf->SetFont('Arial', '', 20); $pdf->Ln(10); $pdf->setFillColor(63, 139, 202); $pdf->SetTextColor(253, 253, 253); $pdf->Cell(0, 10, 'CPU Utilization', 1, 1, 'C', 1); $pdf->TOC_Entry('CPU Utilization', 0); $pdf->SetTextColor(0, 0, 0); $pdf->ln(1); if ($querycpu = mysql_query("SELECT distinct server FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******' group by server")) { while ($query_rowcpu = mysql_fetch_assoc($querycpu)) { $hostname = $query_rowcpu['server']; $cpunumquery = mysql_query("SELECT distinct dbuid,date(cpurep.date)as date,time(cpurep.date) as time,cpurep.user,cpurep.system,cpurep.iowait,cpurep.idle from cpurep,configureddb WHERE cpurep.dbid=configureddb.dbuid and server='{$hostname}' and date(date) = '{$dt}' ORDER BY date desc"); if (mysql_num_rows($cpunumquery)) { $pdf->TOC_Entry($hostname, 1); $pdf->SetFont('Arial', 'B', 14); $pdf->setFillColor(63, 139, 202); $pdf->SetTextColor(253, 253, 253); $pdf->Cell(0, 7, 'Server: ' . $hostname, 1, 1, 'C', 1); $pdf->SetTextColor(0, 0, 0); $pdf->AddCol('time', 55, 'Time ', 'C'); $pdf->AddCol('date', 55, 'Date ', 'C'); $pdf->AddCol('user', 55, '% User', 'C'); $pdf->AddCol('system', 57, '% System ', 'C');
$pdf->Cell(0, 10, 'Database: ' . $databaseName . ' [' . $environ . ']', 0, 1, 'L'); } $longtrans = mysql_query("SELECT * FROM longtrans where date(date) = '{$dt}'"); if (mysql_num_rows($longtrans)) { if ($query = mysql_query("SELECT dbuid,dbname FROM configureddb INNER JOIN dbalogin where dbalogin.username ='******'")) { $pdf->setFillColor(63, 139, 202); $pdf->SetTextColor(253, 253, 253); $pdf->SetFont('Arial', '', 20); $pdf->Cell(0, 10, 'Database Long Running Transaction', 1, 1, 'C', 1); $pdf->TOC_Entry('Database Long Running Transaction', 0); $pdf->SetTextColor(0, 0, 0); while ($query_row = mysql_fetch_assoc($query)) { $dbuid = $query_row['dbuid']; $databaseName = $query_row['dbname']; $pdf->SetFont('Arial', 'B', 15); $pdf->ln(5); $ltsquery = mysql_query("SELECT time(date) as time,date(date)as date,usrno,user,pid,transno,timerunning FROM longtrans WHERE dbid ='{$dbuid}' and date(date) = '{$dt}'"); if (mysql_num_rows($ltsquery)) { $pdf->TOC_Entry($databaseName, 1); $pdf->SetFont('Arial', 'B', 14); $pdf->setFillColor(63, 139, 202); $pdf->SetTextColor(253, 253, 253); $pdf->Cell(0, 7, 'Database: ' . $databaseName, 1, 1, 'C', 1); $pdf->SetTextColor(0, 0, 0); $pdf->AddCol('time', 33, 'Time', 'C'); $pdf->AddCol('date', 34, 'Date', 'C'); $pdf->AddCol('usrno', 40, 'User No', 'C'); $pdf->AddCol('user', 45, 'User', 'C'); $pdf->AddCol('pid', 35, 'Pid'); $pdf->AddCol('transno', 50, 'Transaction No'); $pdf->AddCol('timerunning', 40, 'Time Running(sec)');