<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
<title>
CPU_Line_chart2
</title>
<!-- COMMENT: PHP makes variable available to the rest of the page-->
<? $server_name = $_GET["server_name"] ?>
<? $data_gran = $_GET["data_gran"] ?>
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
</head>
<body style="font-family: Arial;border: 0 none;">
<h2> Capacity Vital Signs </h2>
<form action="http://lpil0219capan01/CPU_Line_chartsarah.php">
Server Name: <input type="text" name="server_name" ><br>
Data Gran: <select name="data_gran">
<option value="hourly">Hourly</option>
<option value="daily">Daily</option>
<option value="monthly">Monthly</option>
</select> <br>
<input type="submit" value="Submit">
</form>
<table border="0" width="100%" cellspacing="0" cellpadding="4">
<tr>
<td width="50%">
<div id="chart001" style="min-width:300px; min-height:300px; margin: 0 auto">
<script type="text/javascript">
google.load('visualization', '1', {packages: ['corechart']});
</script>
<script type="text/javascript">
function drawVisualization() {
// Create and populate the data table.
var data = google.visualization.arrayToDataTable([
['Date', 'MAX', 'MIN', 'AVG'],
<?
$sql = "if '$data_gran' = 'monthly' begin select convert(varchar,YEAR(effect_dte),4) + '-' + convert(varchar,left(datename(mm,effect_dte),3),4) as datestamp,[value_max],[value_min],[value_avg] from dbo.sys_stat_monthly a join METRIC b on a.METRIC_ID = b.METRIC_ID where sys_asset_id='$server_name' and metric_nam='cpu_busy_util'end ".
"else if '$data_gran' = 'hourly' begin select convert(varchar,YEAR(effect_dte),4) + '-' + convert(varchar,left(datename(mm,effect_dte),3),4) + '-'+ convert(varchar,left(datename(dd,effect_dte),3),4) + ' ' + convert(varchar,left(datename(hh,effect_dte),3),4) + ':00' as datestamp,[value_max],[value_min],[value_avg] from dbo.sys_stat_hourly a join METRIC b on a.METRIC_ID = b.METRIC_ID where sys_asset_id='$server_name' and metric_nam='cpu_busy_util' and EFFECT_DTE >= GETDATE() -7 end ".
"else if '$data_gran' = 'daily' begin select convert(varchar,YEAR(effect_dte),4) + '-' + convert(varchar,left(datename(mm,effect_dte),3),4) + '-'+ convert(varchar,left(datename(dd,effect_dte),3),4)as datestamp, [value_max],[value_min],[value_avg] from dbo.sys_stat_daily a join METRIC b on a.METRIC_ID = b.METRIC_ID where sys_asset_id='$server_name' and metric_nam='cpu_busy_util' and EFFECT_DTE >= GETDATE() -30 end ";
$odbc = odbc_connect('CapacityManagementProd', 'caprpt1', '1Cap9Man') or die('could not connect to database');
odbc_prepare($odbc, $sql) or die('could not exec SQL: ' . odbc_errormsg($odbc));
$res = odbc_exec($odbc, $sql) or die('could not exec SQL: ' . odbc_errormsg($odbc));
$counter = 0;
$data = array();
while (odbc_fetch_array($res))
{
$data['effect_dte'] = odbc_result($res, 1);
$data['max'] = odbc_result($res, 2);
$data['min'] = odbc_result($res, 3);
$data['avg'] = odbc_result($res, 4);
if($counter > 0) { ?>,<? }
?>
['<? echo $data['effect_dte']; ?>',<? echo $data['max']; ?> ,<? echo $data['min']?>,<? echo $data['avg']?>]
<?
$counter++;
}
?>
]);
var options =
{
title: 'Simple <? echo $data_gran ?> CPU Chart for <? echo $server_name ?>',
curveType: "function",
width: 700, height: 400,
vAxis: {title:'CPU Util %', maxValue: 100, minValue: 0}
};
// Create and draw the visualization.
document.getElementById('chart001').style.display = 'block';
new google.visualization.LineChart(document.getElementById('chart001')).
draw(data, options);
}
google.setOnLoadCallback(drawVisualization);
</script>
</div>
<small> </small>
</td>
<td width="50%" style="border-left:1px dotted #cccccc;">
<div id="chart002" style="min-width:300px; min-height:300px; margin: 0 auto">
<script type="text/javascript">
google.load('visualization', '1', {packages: ['corechart']});
</script>
<script type="text/javascript">
function drawVisualization() {
// Create and populate the data table.
var data = google.visualization.arrayToDataTable([
['Date', 'MAX', 'MIN', 'AVG'],
<?
$sql = "if '$data_gran' = 'monthly' begin select convert(varchar,YEAR(effect_dte),4) + '-' + convert(varchar,left(datename(mm,effect_dte),3),4) as datestamp,[value_max],[value_min],[value_avg] from dbo.sys_stat_monthly a join METRIC b on a.METRIC_ID = b.METRIC_ID where sys_asset_id='$server_name' and metric_nam= 'mem_used_pct'end ".
"else if '$data_gran' = 'hourly' begin select convert(varchar,YEAR(effect_dte),4) + '-' + convert(varchar,left(datename(mm,effect_dte),3),4) + '-'+ convert(varchar,left(datename(dd,effect_dte),3),4) + ' ' + convert(varchar,left(datename(hh,effect_dte),3),4) + ':00' as datestamp,[value_max],[value_min],[value_avg] from dbo.sys_stat_hourly a join METRIC b on a.METRIC_ID = b.METRIC_ID where sys_asset_id='$server_name' and metric_nam='mem_used_pct' and EFFECT_DTE >= GETDATE() -7 end ".
"else if '$data_gran' = 'daily' begin select convert(varchar,YEAR(effect_dte),4) + '-' + convert(varchar,left(datename(mm,effect_dte),3),4) + '-'+ convert(varchar,left(datename(dd,effect_dte),3),4)as datestamp, [value_max],[value_min],[value_avg] from dbo.sys_stat_daily a join METRIC b on a.METRIC_ID = b.METRIC_ID where sys_asset_id='$server_name' and metric_nam='mem_used_pct' and EFFECT_DTE >= GETDATE() -30 end ";
$odbc = odbc_connect('CapacityManagementProd', 'caprpt1', '1Cap9Man') or die('could not connect to database');
odbc_prepare($odbc, $sql) or die('could not exec SQL: ' . odbc_errormsg($odbc));
$res = odbc_exec($odbc, $sql) or die('could not exec SQL: ' . odbc_errormsg($odbc));
$counter = 0;
$data = array();
while (odbc_fetch_array($res))
{
$data['effect_dte'] = odbc_result($res, 1);
$data['max'] = odbc_result($res, 2);
$data['min'] = odbc_result($res, 3);
$data['avg'] = odbc_result($res, 4);
if($counter > 0) { ?>,<? }
?>
['<? echo $data['effect_dte']; ?>',<? echo $data['max']; ?> ,<? echo $data['min']?>,<? echo $data['avg']?>]
<?
$counter++;
}
?>
]);
document.getElementById('chart002').style.display = 'block';
var options =
{
title: 'Simple <? echo $data_gran ?> MEM Chart for <? echo $server_name ?>',
curveType: "function",
width: 700, height: 400,
vAxis: {title:'MEM Util %', maxValue: 100, minValue: 0},
hAxis: {title:' Date' }
};
// Create and draw the visualization.
document.getElementById('chart002').style.display = 'block';
var chart = new google.visualization.LineChart(document.getElementById('chart002')).
draw(data, options);
}
google.setOnLoadCallback(drawVisualization);
</script>
</div>
<small> </small>
</td>
</tr>
<tr>
<td width="50%" style="border-top:1px dotted #cccccc;">
<div id="chart003" style="min-width:300px; min-height:300px; margin: 0 auto"></div>
<script type="text/javascript">
google.load('visualization', '1', {packages: ['corechart']});
</script>
<script type="text/javascript">
function drawVisualization() {
// Create and populate the data table.
var data = google.visualization.arrayToDataTable([
['Disk', 'Used %'],
<?
$sql = " if '$data_gran' = 'monthly' ".
" begin ".
" select ".
" convert(date,effect_dte), ".
" substring(sys_asset_id,CHARINDEX('^',sys_asset_id)+1,810), ".
" value_max ".
" from SYS_STAT_MONTHLY a join metric b on a.metric_id = b.metric_id ".
" where METRIC_NAM = 'disk_space_used_pct' ".
" and substring(sys_asset_id,1,CHARINDEX('^',sys_asset_id)-1) = '$server_name' ".
" order by SYS_ASSET_ID ".
" end ".
" if '$data_gran' = 'hourly' ".
" begin ".
" select ".
" substring(sys_asset_id,CHARINDEX('^',sys_asset_id)+1,810), ".
" avg(value_max) ".
" from SYS_STAT_hourly a join metric b on a.metric_id = b.metric_id ".
" where METRIC_NAM = 'disk_space_used_pct' ".
" and substring(sys_asset_id,1,CHARINDEX('^',sys_asset_id)-1) = '$server_name' ".
" and EFFECT_DTE >= GETDATE() -3 ".
" group by SYS_ASSET_ID ".
" order by SYS_ASSET_ID ".
" end ".
" if '$data_gran' = 'daily' ".
" begin ".
" select ".
" substring(sys_asset_id,CHARINDEX('^',sys_asset_id)+1,810), ".
" avg(value_max) ".
" from SYS_STAT_Daily a join metric b on a.metric_id = b.metric_id ".
" where METRIC_NAM = 'disk_space_used_pct' ".
" and substring(sys_asset_id,1,CHARINDEX('^',sys_asset_id)-1) = '$server_name' ".
" and EFFECT_DTE >= GETDATE() -30 ".
" group by SYS_ASSET_ID ".
" order by SYS_ASSET_ID ".
" end ";
$odbc = odbc_connect('CapacityManagementProd', 'caprpt1', '1Cap9Man') or die('could not connect to database');
odbc_prepare($odbc, $sql) or die('could not exec SQL: ' . odbc_errormsg($odbc));
$res = odbc_exec($odbc, $sql) or die('could not exec SQL: ' . odbc_errormsg($odbc));
$counter = 0;
$data = array();
while (odbc_fetch_array($res))
{
$data['disk'] = odbc_result($res, 1);
$data['used'] = odbc_result($res, 2);
if($counter > 0) { ?>,<? }
?>
['<? echo $data['disk']; ?>',<? echo $data['used']; ?>]
<?
$counter++;
}
?>
]);
var options =
{
title: 'Simple <? echo $data_gran ?> Disk Chart for <? echo $server_name ?>',
curveType: "function",
width: 700, height: 400,
vAxis: {title:'Disk Util %', maxValue: 100, minValue: 0}
};
// Create and draw the visualization.
new google.visualization.ColumnChart(document.getElementById('chart003')).
draw(data, options);
}
google.setOnLoadCallback(drawVisualization);
</script>
</div>
</td>
<td width="50%" style="border-left:1px dotted #cccccc; border-top:1px dotted #cccccc;">
<div id="chart_4" style="min-width:300px; min-height:300px; margin: 0 auto">sector 4 within div</div>
Network Data going here!!!
</td>
</tr>
</table>
</body>
</html>