View ocum_report_birt.protectunprotectvolumeview | Generated by SchemaSpy |
View Definition:
select `volumelivelistdtoview`.`name` AS `name`,concat(upper(substr(`volumelivelistdtoview`.`protectionRole`,1,1)),lower(substr(`volumelivelistdtoview`.`protectionRole`,2))) AS `protectionrole`,`volumelivelistdtoview`.`clusterNodeName` AS `clusternodeName`,`volumelivelistdtoview`.`clusterName` AS `clustername` from `ocum`.`volumelivelistdtoview` where (`volumelivelistdtoview`.`protectionRole` in ('protected','unprotected','destination'))