View ocum.datasourcelivelistdtoview | Generated by SchemaSpy |
View Definition:
select `ocum`.`datasource`.`id` AS `id`,(case when (`inventorycluster`.`name` is not null) then `inventorycluster`.`name` else `ocum`.`datasource`.`objectName` end) AS `name`,`ocum`.`datasource`.`operation` AS `operation`,`ocum`.`datasource`.`operationState` AS `operationState`,`ocum`.`datasource`.`operationStartTime` AS `operationStartTime`,`ocum`.`datasource`.`operationEndTime` AS `operationEndTime`,`ocum`.`datasource`.`lastOperationSuccessTime` AS `lastOperationSuccessTime`,`ocum`.`datasource`.`lastOperationFailureTime` AS `lastOperationFailureTime`,`inventorycluster`.`objid` AS `clusterId`,(`na_timeSinceTimestampInSeconds`(`ocum`.`datasource`.`lastOperationSuccessTime`) * 1000) AS `durationSinceLastSuccess`,(`na_timeSinceTimestampInSeconds`(`ocum`.`datasource`.`lastOperationFailureTime`) * 1000) AS `durationSinceLastFailure` from ((`ocum`.`datasource` left join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`datasourceId` = `ocum`.`datasource`.`id`))) left join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`)))
Possibly Referenced Tables/Views: