View ocum.annotationvaluebreakdownlivelistdtoview | Generated by SchemaSpy |
View Definition:
select `annotationtypevalueview`.`annotationTypeId` AS `annotationTypeId`,`annotationtypevalueview`.`annotationTypeName` AS `annotationTypeName`,0 AS `healthStatus`,`annotationtypevalueview`.`annotationValueId` AS `annotationValueId`,`annotationtypevalueview`.`annotationValueName` AS `annotationValueName`,concat(`annotationtypevalueview`.`annotationTypeName`,'=',`annotationtypevalueview`.`annotationValueName`) AS `annotationValueFullName`,0 AS `annotationValueHealthStatus`,sum(if((`ocum`.`annotationresourceobject`.`resource_type` = 'cluster'),1,0)) AS `clusterCount`,sum(if((`ocum`.`annotationresourceobject`.`resource_type` = 'vserver'),1,0)) AS `vservercount`,sum(if((`ocum`.`annotationresourceobject`.`resource_type` = 'volume'),1,0)) AS `volumecount` from (`ocum`.`annotationtypevalueview` left join `ocum`.`annotationresourceobject` on(((`annotationtypevalueview`.`annotationTypeId` = `ocum`.`annotationresourceobject`.`annotationType_id`) and (`annotationtypevalueview`.`annotationValueId` = `ocum`.`annotationresourceobject`.`annotation_id`)))) group by `annotationtypevalueview`.`annotationTypeName`,`annotationtypevalueview`.`annotationValueName`
Possibly Referenced Tables/Views: