View netapp_model_view.storage_shelf | Generated by SchemaSpy |
View Definition:
select `netapp_model`.`storage_shelf`.`objid` AS `objid`,`netapp_model`.`storage_shelf`.`uuid` AS `uuid`,`netapp_model`.`storage_shelf`.`resourceKey` AS `resourceKey`,`netapp_model`.`storage_shelf`.`clusterId` AS `clusterId`,`netapp_model`.`storage_shelf`.`nodeId` AS `nodeId`,`netapp_model`.`storage_shelf`.`partnerNodeId` AS `partnerNodeId`,`netapp_model`.`storage_shelf`.`shelfUuid` AS `shelfUuid`,`netapp_model`.`storage_shelf`.`shelfIdentifier` AS `shelfIdentifier`,`netapp_model`.`storage_shelf`.`sesProductId` AS `sesProductId`,`netapp_model`.`storage_shelf`.`firmwareRevisionA` AS `firmwareRevisionA`,`netapp_model`.`storage_shelf`.`firmwareRevisionB` AS `firmwareRevisionB`,`netapp_model`.`storage_shelf`.`module` AS `module`,`netapp_model`.`storage_shelf`.`channelName` AS `channelName`,`netapp_model`.`storage_shelf`.`shelfType` AS `shelfType`,`netapp_model`.`storage_shelf`.`state` AS `state`,`netapp_model`.`storage_shelf`.`stateRaw` AS `stateRaw`,`netapp_model`.`storage_shelf`.`isLocalAttach` AS `isLocalAttach`,`netapp_model`.`storage_shelf`.`stackId` AS `stackId`,`netapp_model`.`storage_shelf`.`temperatureSensorCount` AS `temperatureSensorCount`,`netapp_model`.`storage_shelf`.`temperatureSensorFailedCount` AS `temperatureSensorFailedCount`,`netapp_model`.`storage_shelf`.`coolingElementCount` AS `coolingElementCount`,`netapp_model`.`storage_shelf`.`coolingElementFailedCount` AS `coolingElementFailedCount`,`netapp_model`.`storage_shelf`.`powerSupplyCount` AS `powerSupplyCount`,`netapp_model`.`storage_shelf`.`powerSupplyFailedCount` AS `powerSupplyFailedCount`,`netapp_model`.`storage_shelf`.`currentSensorCount` AS `currentSensorCount`,`netapp_model`.`storage_shelf`.`currentSensorFailedCount` AS `currentSensorFailedCount`,`netapp_model`.`storage_shelf`.`voltageSensorCount` AS `voltageSensorCount`,`netapp_model`.`storage_shelf`.`voltageSensorFailedCount` AS `voltageSensorFailedCount`,`netapp_model`.`storage_shelf`.`createtime` AS `createTime`,`netapp_model`.`storage_shelf`.`updatetime` AS `updateTime` from `netapp_model`.`storage_shelf` where (`netapp_model`.`storage_shelf`.`objState` = 'LIVE')