View ocum.lunnodecapacitymapping | Generated by SchemaSpy |
View Definition:
select if(isnull(`lun`.`isMapped`),0,`lun`.`isMapped`) AS `isLunMapped`,`inventoryvolume`.`nodeId` AS `nodeId`,sum((case when (`lun`.`isMapped` is true) then `lun`.`size` else 0 end)) AS `assignedLunCapacity`,sum((case when (`lun`.`isMapped` is false) then `lun`.`size` when isnull(`lun`.`isMapped`) then `lun`.`size` else 0 end)) AS `unassignedLunCapacity` from (`netapp_model_view`.`lun` left join `netapp_model_view`.`volume` `inventoryvolume` on((`inventoryvolume`.`objid` = `lun`.`volumeId`))) group by `isLunMapped`,`inventoryvolume`.`nodeId`
Possibly Referenced Tables/Views: