2,187
edits
(Initial creation) |
m (Corrections) |
||
Line 210: | Line 210: | ||
if ($row['thin'] == 1) { | if ($row['thin'] == 1) { | ||
print "Thin"; | print "Thin"; | ||
} elseif ($row['rdm'] == 1 { | } elseif ($row['rdm'] == 1) { | ||
print "RDM"; | print "RDM"; | ||
} else | } else { | ||
print "Thick"; | print "Thick"; | ||
} | } | ||
Line 223: | Line 223: | ||
print "\n<tr><td><td valign='top'>\n"; | print "\n<tr><td><td valign='top'>\n"; | ||
$query = "SELECT san_model, lun, ds.dsid, ds.name, ds.size, ds.used, SUM(vmdk.size) AS vm_used, mpath FROM ds JOIN vmdk USING (dsid) JOIN esx2ds USING (dsid) WHERE vmid=". $_REQUEST["vmid"]." AND esxid=$esxid GROUP BY lun;"; | $query = "SELECT san_model, lun, ds.dsid, ds.name, ds.size, ds.used, SUM(IF(vmdk.rdm=1,0,vmdk.size)) AS vm_used, mpath FROM ds JOIN vmdk USING (dsid) JOIN esx2ds USING (dsid) WHERE vmid=". $_REQUEST["vmid"]." AND esxid=$esxid GROUP BY lun;"; | ||
if ($debug) {print ($query);} | if ($debug) {print ($query);} | ||
$result = mysql_query($query); | $result = mysql_query($query); |