View netapp_model_view.file | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`file`.`objid` AS `objid`,`netapp_model`.`file`.`uuid` AS `uuid`,`netapp_model`.`file`.`resourceKey` AS `resourceKey`,`netapp_model`.`file`.`volumeId` AS `volumeId`,`netapp_model`.`file`.`vserverId` AS `vserverId`,`netapp_model`.`file`.`clusterId` AS `clusterId`,`netapp_model`.`file`.`qosPolicyGroupId` AS `qosPolicyGroupId`,`netapp_model`.`file`.`path` AS `path`,`netapp_model`.`file`.`isOnline` AS `isOnline`,`netapp_model`.`file`.`size` AS `size`,`netapp_model`.`file`.`sizeUsed` AS `sizeUsed`,`netapp_model`.`file`.`isSpaceReservationEnabled` AS `isSpaceReservationEnabled`,`netapp_model`.`file`.`isSpaceAllocEnabled` AS `isSpaceAllocEnabled`,`netapp_model`.`file`.`isMapped` AS `isMapped`,`netapp_model`.`file`.`serialNumber` AS `serialNumber`,`netapp_model`.`file`.`multiProtocolType` AS `multiProtocolType`,`netapp_model`.`file`.`alignmentRaw` AS `alignmentRaw`,`netapp_model`.`file`.`prefixSize` AS `prefixSize`,`netapp_model`.`file`.`suffixSize` AS `suffixSize`,`netapp_model`.`file`.`classRaw` AS `classRaw`,`netapp_model`.`file`.`comment` AS `comment`,`netapp_model`.`file`.`createtime` AS `createTime`,`netapp_model`.`file`.`updatetime` AS `updateTime` from `netapp_model`.`file` where (`netapp_model`.`file`.`objState` = 'LIVE')