View ocum.clusterlivelistdtoview 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
id bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
name varchar 255 Textual name
healthStatus int 10
fqdn varchar 255  √  null
primaryHostName varchar 255  √  null Address used to acquire information about this cluster
contact varchar 255  √  null The contact information for the cluster, ZAPIs: cluster-identity-get cluster-contact
location varchar 255  √  null The location of the cluster, ZAPIs: cluster-identity-get cluster-location
serialNumber varchar 255  √  null Serial number
sslFipsEnabled bit 0  √  null Indicates whether or not SSL FIPS 140-2 is Enabled
shortOSVersion varchar 1024  √  null
numberOfNodes bigint 19  √  null
lastUpdateTime bigint 19  √  null
durationSinceLastUpdate bigint 19  √  null
diagnosisStatus varchar 255  √  null Overall system health as determined by diagnosis framework - ZAPI raw value
communicationStatus int 10  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventorycluster`.`objid` AS `id`,`inventorycluster`.`name` AS `name`,`ocum`.`cluster`.`healthStatus` AS `healthStatus`,`ocum`.`cluster`.`fqdn` AS `fqdn`,`inventorycluster`.`managementIp` AS `primaryHostName`,`inventorycluster`.`contact` AS `contact`,`inventorycluster`.`location` AS `location`,`inventorycluster`.`serialNumber` AS `serialNumber`,`inventorycluster`.`sslFipsEnabled` AS `sslFipsEnabled`,`na_shortOSVersion`(`inventorycluster`.`version`) AS `shortOSVersion`,(select count(0) from `netapp_model_view`.`node` where (`node`.`clusterId` = `inventorycluster`.`objid`)) AS `numberOfNodes`,`inventorycluster`.`lastUpdateTime` AS `lastUpdateTime`,(select ((unix_timestamp() * 1000) - `inventorycluster`.`lastUpdateTime`)) AS `durationSinceLastUpdate`,`inventorycluster`.`diagnosisStatusRaw` AS `diagnosisStatus`,`ocum`.`datasource`.`communicationStatus` AS `communicationStatus` from ((`netapp_model_view`.`cluster` `inventorycluster` straight_join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`))) straight_join `ocum`.`datasource` on((`ocum`.`datasource`.`id` = `ocum`.`cluster`.`dataSource_id`)))
 
Possibly Referenced Tables/Views: