View netapp_model_view.storage_switch Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
objid bigint 19 Locally unique object identifier. ZAPI: storage-pool-get-iter.storage-pool-info
uuid varchar 255 Derived from WWN. Not from ZAPI. DERIVED: {WWN}
resourceKey varchar 512
name varchar 255 Name of the switch
clusterId bigint 19
wwn varchar 255 World Wide Name of the switch
vendor varchar 255 Vendor of the switch. E.g.: 'cisco' or 'brocade'
firmwareVersion varchar 255 Firmware version of the switch
ipAddress varchar 255 IP address of the switch
model varchar 255 Model of the switch
role enum 11  √  null Role of switch in the fabric
roleRaw varchar 255  √  null Role of switch in the fabric
status enum 11  √  null Status of switch in the fabric
statusRaw varchar 255  √  null Status of switch in the fabric
sensorCount int 10  √  null Sensor count
powerSupplyCount int 10  √  null Power supply count
fanCount int 10  √  null Fan count
createTime bigint 19
updateTime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`storage_switch`.`objid` AS `objid`,`netapp_model`.`storage_switch`.`uuid` AS `uuid`,`netapp_model`.`storage_switch`.`resourceKey` AS `resourceKey`,`netapp_model`.`storage_switch`.`name` AS `name`,`netapp_model`.`storage_switch`.`clusterId` AS `clusterId`,`netapp_model`.`storage_switch`.`wwn` AS `wwn`,`netapp_model`.`storage_switch`.`vendor` AS `vendor`,`netapp_model`.`storage_switch`.`firmwareVersion` AS `firmwareVersion`,`netapp_model`.`storage_switch`.`ipAddress` AS `ipAddress`,`netapp_model`.`storage_switch`.`model` AS `model`,`netapp_model`.`storage_switch`.`role` AS `role`,`netapp_model`.`storage_switch`.`roleRaw` AS `roleRaw`,`netapp_model`.`storage_switch`.`status` AS `status`,`netapp_model`.`storage_switch`.`statusRaw` AS `statusRaw`,`netapp_model`.`storage_switch`.`sensorCount` AS `sensorCount`,`netapp_model`.`storage_switch`.`powerSupplyCount` AS `powerSupplyCount`,`netapp_model`.`storage_switch`.`fanCount` AS `fanCount`,`netapp_model`.`storage_switch`.`createtime` AS `createTime`,`netapp_model`.`storage_switch`.`updatetime` AS `updateTime` from `netapp_model`.`storage_switch` where (`netapp_model`.`storage_switch`.`objState` = 'LIVE')