View ocum.clusterlivelistdtoview | Generated by SchemaSpy |
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: