View netapp_model_view.storage_service_full | Generated by SchemaSpy |
View Definition:
select `service`.`objid` AS `objid`,`service`.`UUID` AS `uuid`,`service`.`resourceKey` AS `resourceKey`,`service`.`clusterId` AS `clusterId`,`service`.`vserverId` AS `vserverId`,`ssv`.`volumeId` AS `volumeId`,`service`.`storageServiceIdentifier` AS `storageServiceIdentifier`,`service`.`storageServiceName` AS `storageServiceName`,`service`.`sizeUsed` AS `sizeUsed`,`service`.`sizeTotal` AS `sizeTotal`,`service`.`sizeUsedBySnapshots` AS `sizeUsedBySnapshots`,`service`.`snapshotReserveSize` AS `snapshotReserveSize`,`service`.`deduplicationSpaceSaved` AS `deduplicationSpaceSaved`,`service`.`compressionSpaceSaved` AS `compressionSpaceSaved`,`service`.`createtime` AS `createTime`,`service`.`updatetime` AS `updateTime`,`service`.`objState` AS `objState` from (`netapp_model`.`storage_service` `service` left join `netapp_model`.`storage_service_volume_relationship` `ssv` on((`service`.`objid` = `ssv`.`objid`)))