View ocum.resourcepoollivelistdtoview | Generated by SchemaSpy |
View Definition:
select `ocum`.`resourcepool`.`id` AS `id`,`ocum`.`resourcepool`.`objectName` AS `name`,`ocum`.`resourcepool`.`resourceKey` AS `resourceKey`,`ocum`.`resourcepool`.`description` AS `description`,`ocum`.`resourcepool`.`snapLockType` AS `snapLockType`,`ocum`.`resourcepool`.`capacityTotal` AS `capacityTotal`,`ocum`.`resourcepool`.`capacityUsed` AS `capacityUsed`,(case when (`ocum`.`resourcepool`.`capacityTotal` = 0) then 0 else ((`ocum`.`resourcepool`.`capacityUsed` / `ocum`.`resourcepool`.`capacityTotal`) * 100) end) AS `capacityUsedPercent`,`ocum`.`resourcepool`.`capacityAvailable` AS `capacityAvailable` from `ocum`.`resourcepool`
Possibly Referenced Tables/Views: