View ocum.aggregatelivelistdtoview 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: aggr-get-iter.aggr-attributes
name varchar 255 Textual name
healthStatus int 10
state varchar 255  √  null
clusterNodeId bigint 19 Locally unique object identifier. ZAPIs: system-node-get-iter.node-details-info, system-get-node-info-iter.system-info
clusterNodeName varchar 255 Textual name
clusterNodeHealthStatus int 10
clusterId bigint 19 Locally unique object identifier. ZAPIs: cluster-identity-get.cluster-identity-info
clusterName varchar 255 Textual name
clusterHealthStatus int 10
dfBytesUsed bigint 19  √  null Number of bytes used in the referenced file system. If the referenced file system is restricted or offline, a value of 0 is returned
dfBytesUsedPercent decimal 26,4  √  null
dfBytesAvail bigint 19  √  null Number of bytes still available in the referenced file system. ZAPIs: aggr-get-iter aggr-space-attributes size-available
dfBytesAvailPercent decimal 26,4  √  null
dfBytesTotal bigint 19  √  null Total size (in bytes) of the referenced file system . If the referenced file system is restricted or offline, a value of 0 is returned
dfBytesTotalCommitted bigint 19  √  null A derived measure of the committed capacity of all Volumes on this Aggregate. "Committed" here is defined as the total capacity a volume might consume if entirely full.
raidStatus varchar 255  √  null RAID status as string
aggregateDerivedType enum 17  √  null Aggregate Derived Type.
usedExternalTierCapacity bigint 19  √  null
raidType varchar 255  √  null
aggregateType varchar 10  √  null
isHybridEnabled bit 0  √  null If true, aggregate is eligible to contain both SSD and non-SSD RAID groups
isCftPrecommit int 10  √  null
hasLocalRoot bit 0  √  null Whether the aggregate contains the local root volume. ZAPIs: aggr-get-iter has-local-root.
hasPartnerRoot bit 0  √  null Whether the aggregate contains the partner's root volume. ZAPIs: aggr-get-iter has-partner-root.
totalStorageEfficiencyRatio varchar 20  √  null Indicates the total storage efficiency ratio of an aggregate
resourcePoolId bigint 19  √  null
versionGeneration int 10  √  null First integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
versionMajor int 10  √  null Second integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
versionMinor int 10  √  null Third integer of the Data ONTAP version tuple corresponding to the lowest version across the cluster
resyncPercent decimal 32  √  null
mirrorStatusRaw varchar 255  √  null
snapLockType varchar 255  √  null
clusterFqdn varchar 255  √  null

Analyzed at Tue Apr 23 05:29 EDT 2019

View Definition:
select `inventoryaggregate`.`objid` AS `id`,`inventoryaggregate`.`name` AS `name`,`ocum`.`aggregate`.`healthStatus` AS `healthStatus`,`inventoryaggregate`.`stateRaw` AS `state`,`inventoryclusternode`.`objid` AS `clusterNodeId`,`inventoryclusternode`.`name` AS `clusterNodeName`,`ocum`.`clusternode`.`healthStatus` AS `clusterNodeHealthStatus`,`inventorycluster`.`objid` AS `clusterId`,`inventorycluster`.`name` AS `clusterName`,`ocum`.`cluster`.`healthStatus` AS `clusterHealthStatus`,`inventoryaggregate`.`sizeUsed` AS `dfBytesUsed`,`aggregatecalculationsview`.`dfBytesUsedPercent` AS `dfBytesUsedPercent`,`inventoryaggregate`.`sizeAvail` AS `dfBytesAvail`,`aggregatecalculationsview`.`dfBytesAvailPercent` AS `dfBytesAvailPercent`,`inventoryaggregate`.`sizeTotal` AS `dfBytesTotal`,`inventoryaggregate`.`totalCommitted` AS `dfBytesTotalCommitted`,`inventoryaggregate`.`raidStatus` AS `raidStatus`,`inventoryaggregate`.`aggregateDerivedType` AS `aggregateDerivedType`,`inventoryaggregate`.`totalUsedExternalLicensedSpace` AS `usedExternalTierCapacity`,(case when (`inventoryaggregate`.`raidTypeRaw` = 'raid_0') then 'raid0' when (`inventoryaggregate`.`raidTypeRaw` = 'raid_4') then 'raid4' else `inventoryaggregate`.`raidTypeRaw` end) AS `raidType`,(case when (`inventoryaggregate`.`isComposite` = TRUE) then 'fabricPool' when (`inventoryaggregate`.`aggregateTypeRaw` = 'ssd') then 'ssd' when (`inventoryaggregate`.`isHybridEnabled` = TRUE) then 'flashPool' when ((`inventoryaggregate`.`aggregateTypeRaw` = 'vmdisk') or (`inventoryaggregate`.`aggregateTypeRaw` = 'hdd') or (`inventoryaggregate`.`aggregateTypeRaw` = 'lun')) then 'standard' end) AS `aggregateType`,`inventoryaggregate`.`isHybridEnabled` AS `isHybridEnabled`,(case when isnull(`inventoryaggregate`.`isCftPreCommit`) then FALSE else `inventoryaggregate`.`isCftPreCommit` end) AS `isCftPrecommit`,`inventoryaggregate`.`hasLocalRoot` AS `hasLocalRoot`,`inventoryaggregate`.`hasPartnerRoot` AS `hasPartnerRoot`,`inventoryaggregate`.`totalStorageEfficiencyRatio` AS `totalStorageEfficiencyRatio`,`ocum`.`resourcepoolaggregates`.`resourcePool_id` AS `resourcePoolId`,`inventorycluster`.`versionGeneration` AS `versionGeneration`,`inventorycluster`.`versionMajor` AS `versionMajor`,`inventorycluster`.`versionMinor` AS `versionMinor`,sum(`inventoryplex`.`resyncPercent`) AS `resyncPercent`,`inventoryaggregate`.`mirrorStatusRaw` AS `mirrorStatusRaw`,(case when (`inventoryaggregate`.`isSnapLock` = FALSE) then 'non_snaplock' else `inventoryaggregate`.`snapLockTypeRaw` end) AS `snapLockType`,`ocumschemacluster`.`fqdn` AS `clusterFqdn` from (((((((((`netapp_model_view`.`aggregate` `inventoryaggregate` straight_join `ocum`.`aggregate` on((`ocum`.`aggregate`.`id` = `inventoryaggregate`.`objid`))) straight_join `netapp_model_view`.`node` `inventoryclusternode` on((`inventoryclusternode`.`objid` = `inventoryaggregate`.`nodeId`))) straight_join `ocum`.`clusternode` on((`ocum`.`clusternode`.`id` = `inventoryclusternode`.`objid`))) straight_join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryaggregate`.`clusterId`))) straight_join `ocum`.`cluster` on((`ocum`.`cluster`.`id` = `inventorycluster`.`objid`))) straight_join `ocum`.`aggregatecalculationsview` on((`aggregatecalculationsview`.`aggregateId` = `inventoryaggregate`.`objid`))) left join `ocum`.`resourcepoolaggregates` on((`ocum`.`resourcepoolaggregates`.`aggregate_id` = `inventoryaggregate`.`objid`))) left join `netapp_model_view`.`plex` `inventoryplex` on((`inventoryplex`.`aggregateId` = `inventoryaggregate`.`objid`))) join `ocum`.`cluster` `ocumschemacluster` on((`ocumschemacluster`.`cluster_id` = `inventoryaggregate`.`clusterId`))) group by `inventoryaggregate`.`objid`
 
Possibly Referenced Tables/Views: