View netapp_model_view.snapshot | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`snapshot`.`objid` AS `objid`,`netapp_model`.`snapshot`.`uuid` AS `uuid`,`netapp_model`.`snapshot`.`resourceKey` AS `resourceKey`,`netapp_model`.`snapshot`.`volumeId` AS `volumeId`,`netapp_model`.`snapshot`.`vserverId` AS `vserverId`,`netapp_model`.`snapshot`.`clusterId` AS `clusterId`,`netapp_model`.`snapshot`.`instanceUUID` AS `instanceUUID`,`netapp_model`.`snapshot`.`versionUUID` AS `versionUUID`,`netapp_model`.`snapshot`.`name` AS `name`,`netapp_model`.`snapshot`.`isBusy` AS `isBusy`,`netapp_model`.`snapshot`.`accessTime` AS `accessTime`,`netapp_model`.`snapshot`.`dependency` AS `dependency`,`netapp_model`.`snapshot`.`percentageOfTotalBlocks` AS `percentageOfTotalBlocks`,`netapp_model`.`snapshot`.`cumulativePercentageOfTotalBlocks` AS `cumulativePercentageOfTotalBlocks`,`netapp_model`.`snapshot`.`createtime` AS `createTime`,`netapp_model`.`snapshot`.`updatetime` AS `updateTime` from `netapp_model`.`snapshot` where (`netapp_model`.`snapshot`.`objState` = 'LIVE')