View netapp_model_view.namespace | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`namespace`.`objid` AS `objid`,`netapp_model`.`namespace`.`uuid` AS `uuid`,`netapp_model`.`namespace`.`resourceKey` AS `resourceKey`,`netapp_model`.`namespace`.`qtreeId` AS `qtreeId`,`netapp_model`.`namespace`.`volumeId` AS `volumeId`,`netapp_model`.`namespace`.`vserverId` AS `vserverId`,`netapp_model`.`namespace`.`clusterId` AS `clusterId`,`netapp_model`.`namespace`.`qosPolicyGroupId` AS `qosPolicyGroupId`,`netapp_model`.`namespace`.`path` AS `path`,`netapp_model`.`namespace`.`subsystem` AS `subsystem`,`netapp_model`.`namespace`.`isReadOnly` AS `isReadOnly`,`netapp_model`.`namespace`.`restoreInaccessible` AS `restoreInaccessible`,`netapp_model`.`namespace`.`size` AS `size`,`netapp_model`.`namespace`.`sizeUsed` AS `sizeUsed`,`netapp_model`.`namespace`.`blockSize` AS `blockSize`,`netapp_model`.`namespace`.`state` AS `state`,`netapp_model`.`namespace`.`stateRaw` AS `stateRaw`,`netapp_model`.`namespace`.`osType` AS `osType`,`netapp_model`.`namespace`.`osTypeRaw` AS `osTypeRaw`,`netapp_model`.`namespace`.`comment` AS `comment`,`netapp_model`.`namespace`.`createtime` AS `createtime`,`netapp_model`.`namespace`.`updatetime` AS `updatetime` from `netapp_model`.`namespace` where (`netapp_model`.`namespace`.`objState` = 'LIVE')