View netapp_model_view.system_health_alert 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.
uuid varchar 512 Globally unique ID of the SHM events Derived: {clusterUUID}.alertId.alertingResource
resourceKey varchar 512
alertId varchar 255 Alert identification
alertingResource varchar 255 Unique name of resource that generated the alert
alertingResourceName varchar 255  √  null Display name of resource that generated the alert.
clusterId bigint 19 Cluseter objid hosting this health monitor
nodeId bigint 19 Node objid hosting this health monitor
indicationTime timestamp 19 0000-00-00 00:00:00 Time of alert generation
monitor enum 14  √  null Type of health monitor
monitorRAW varchar 45  √  null Type of health monitor. Value from ZAPI
perceivedSeverity varchar 45  √  null Severity of alert
policy varchar 255  √  null Policy rule responsible for creating this alert
possibleEffect varchar 512  √  null Possible effect seen due to this problem
correctiveActions text 65535  √  null Recommended actions to correct the problem reported by alert
probableCause varchar 512  √  null Probable cause for alert generation
probableCauseDescription text 65535  √  null Detailed description of probable cause for alert generation
subsystem varchar 255  √  null Type of subsystem being monitored
additionalInfo text 65535  √  null Additional information from the resource that generated this alert
acknowledge bit 0  √  null Acknowledge the alert condition
acknowledger varchar 512  √  null Person who acknowledged this alert
suppress bit 0  √  null Suppress this alert
suppressor varchar 512  √  null Person who suppressed this alert
createtime bigint 19
updatetime bigint 19

Analyzed at Tue Apr 23 04:50 EDT 2019

View Definition:
select `netapp_model`.`system_health_alert`.`objid` AS `objid`,`netapp_model`.`system_health_alert`.`uuid` AS `uuid`,`netapp_model`.`system_health_alert`.`resourceKey` AS `resourceKey`,`netapp_model`.`system_health_alert`.`alertId` AS `alertId`,`netapp_model`.`system_health_alert`.`alertingResource` AS `alertingResource`,`netapp_model`.`system_health_alert`.`alertingResourceName` AS `alertingResourceName`,`netapp_model`.`system_health_alert`.`clusterId` AS `clusterId`,`netapp_model`.`system_health_alert`.`nodeId` AS `nodeId`,`netapp_model`.`system_health_alert`.`indicationTime` AS `indicationTime`,`netapp_model`.`system_health_alert`.`monitor` AS `monitor`,`netapp_model`.`system_health_alert`.`monitorRAW` AS `monitorRAW`,`netapp_model`.`system_health_alert`.`perceivedSeverity` AS `perceivedSeverity`,`netapp_model`.`system_health_alert`.`policy` AS `policy`,`netapp_model`.`system_health_alert`.`possibleEffect` AS `possibleEffect`,`netapp_model`.`system_health_alert`.`correctiveActions` AS `correctiveActions`,`netapp_model`.`system_health_alert`.`probableCause` AS `probableCause`,`netapp_model`.`system_health_alert`.`probableCauseDescription` AS `probableCauseDescription`,`netapp_model`.`system_health_alert`.`subsystem` AS `subsystem`,`netapp_model`.`system_health_alert`.`additionalInfo` AS `additionalInfo`,`netapp_model`.`system_health_alert`.`acknowledge` AS `acknowledge`,`netapp_model`.`system_health_alert`.`acknowledger` AS `acknowledger`,`netapp_model`.`system_health_alert`.`suppress` AS `suppress`,`netapp_model`.`system_health_alert`.`suppressor` AS `suppressor`,`netapp_model`.`system_health_alert`.`createtime` AS `createtime`,`netapp_model`.`system_health_alert`.`updatetime` AS `updatetime` from `netapp_model`.`system_health_alert` where (`netapp_model`.`system_health_alert`.`objState` = 'LIVE')