1
select `labtech`.`hvmconfig`.`HVMName` AS `VMName`,`labtech`.`hvstoragedisk`.`HVHID` AS `HVHID`,`labtech`.`hvstoragedisk`.`HVSSize` AS `HVSSize`,`labtech`.`hvstoragedisk`.`HVSFreeSize` AS `HVSFreeSize`,`labtech`.`hvstoragedisk`.`HVDiskPath` AS `HVDiskPath`,(`labtech`.`hvstoragedisk`.`HVSFreeSize` / `labtech`.`hvstoragedisk`.`HVSSize`) AS `PercentDiskFree`,`labtech`.`hvstoragedisk`.`VMInstanceID` AS `VMInstanceID` from (`labtech`.`hvmconfig` left join `labtech`.`hvstoragedisk` on((`labtech`.`hvmconfig`.`HVHID` = `labtech`.`hvstoragedisk`.`HVHID`)))