View ocum.exportrulelivelistdtoview 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: export-rule-get-iter.export-rule-info
exportPolicyId bigint 19 Locally unique object identifier. ZAPIs: export-policy-get-iter.export-policy-info
exportPolicyName varchar 255  √  null Name of the policy
exportPolicyHealthStatus int 10
ruleIndex int 10  √  null Export rule index
accessProtocol varchar 255 Client access protocol. Default value is 'any'. May be comma separated
clientMatch varchar 255 Client match specification for Export rule. The clients specified are enforced with this Export rule. The rule with the higher rule index value takes precedence
roRule varchar 255  √  null Rule for read-only access. Ordered, comma separated list of the array values in ONTAP.
rwRule varchar 255  √  null Rule for read-write access. Ordered, comma separated list of the array values in ONTAP.
vserverId bigint 19 Locally unique object identifier. ZAPIs: vserver-get-iter.vserver-info
vserverName varchar 255 Textual name
vserverHealthStatus int 10

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventoryexportrule`.`objid` AS `id`,`inventoryexportpolicy`.`objid` AS `exportPolicyId`,`inventoryexportpolicy`.`name` AS `exportPolicyName`,`ocum`.`exportpolicy`.`healthStatus` AS `exportPolicyHealthStatus`,`inventoryexportrule`.`ruleIndex` AS `ruleIndex`,`inventoryexportrule`.`accessProtocol` AS `accessProtocol`,`inventoryexportrule`.`clientMatch` AS `clientMatch`,`inventoryexportrule`.`roRule` AS `roRule`,`inventoryexportrule`.`rwRule` AS `rwRule`,`inventoryvserver`.`objid` AS `vserverId`,`inventoryvserver`.`name` AS `vserverName`,`ocum`.`vserver`.`healthStatus` AS `vserverHealthStatus` from ((((`netapp_model_view`.`export_rule` `inventoryexportrule` straight_join `netapp_model_view`.`export_policy` `inventoryexportpolicy` on((`inventoryexportrule`.`exportPolicyId` = `inventoryexportpolicy`.`objid`))) straight_join `ocum`.`exportpolicy` on((`ocum`.`exportpolicy`.`id` = `inventoryexportpolicy`.`objid`))) straight_join `netapp_model_view`.`vserver` `inventoryvserver` on((`inventoryexportrule`.`vserverId` = `inventoryvserver`.`objid`))) straight_join `ocum`.`vserver` on((`ocum`.`vserver`.`id` = `inventoryvserver`.`objid`)))
 
Possibly Referenced Tables/Views: