View ocum.datasourcelivelistdtoview 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 int 10
name varchar 255  √  null
operation int 10  √  1
operationState int 10  √  0
operationStartTime timestamp 19  √  null
operationEndTime timestamp 19  √  null
lastOperationSuccessTime timestamp 19  √  null
lastOperationFailureTime timestamp 19  √  null
clusterId bigint 19  √  null Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
durationSinceLastSuccess bigint 19  √  null
durationSinceLastFailure bigint 19  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

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: