View netapp_model_view.flash_device | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`flash_device`.`objid` AS `objid`,`netapp_model`.`flash_device`.`uuid` AS `uuid`,`netapp_model`.`flash_device`.`resourceKey` AS `resourceKey`,`netapp_model`.`flash_device`.`clusterId` AS `clusterId`,`netapp_model`.`flash_device`.`nodeId` AS `nodeId`,`netapp_model`.`flash_device`.`slotNumber` AS `slotNumber`,`netapp_model`.`flash_device`.`serialNumber` AS `serialNumber`,`netapp_model`.`flash_device`.`modelName` AS `modelName`,`netapp_model`.`flash_device`.`firmwareRevision` AS `firmwareRevision`,`netapp_model`.`flash_device`.`capacityGB` AS `capacityGB`,`netapp_model`.`flash_device`.`percentOnline` AS `percentOnline`,`netapp_model`.`flash_device`.`status` AS `status`,`netapp_model`.`flash_device`.`statusRaw` AS `statusRaw`,`netapp_model`.`flash_device`.`serviceTime` AS `serviceTime`,`netapp_model`.`flash_device`.`thresholdProfile` AS `thresholdProfile`,`netapp_model`.`flash_device`.`createtime` AS `createTime`,`netapp_model`.`flash_device`.`updatetime` AS `updateTime` from `netapp_model`.`flash_device` where (`netapp_model`.`flash_device`.`objState` = 'LIVE')