View ocum_report.clusterlicensedetailview 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
clusterName varchar 255
licensePackage varchar 255  √  null
licenseDecription varchar 255  √  null
licenseType varchar 255  √  null
licenseStatus text 65535  √  null
licenseSerialNumber varchar 255  √  null
licenseExpirationTime timestamp 19  √  null

Analyzed at Tue Apr 23 04:52 EDT 2019

View Definition:
select `inventorycluster`.`name` AS `clusterName`,`inventorylicense`.`package` AS `licensePackage`,`inventorylicense`.`description` AS `licenseDecription`,`inventorylicense`.`licenseTypeRaw` AS `licenseType`,`ocum`.`na_boolToEnabledDisabled`((`inventorylicense`.`licenseTypeRaw` is not null)) AS `licenseStatus`,`inventorylicense`.`serialNumber` AS `licenseSerialNumber`,`inventorylicense`.`expirationTime` AS `licenseExpirationTime` from ((`netapp_model_view`.`license` `inventorylicense` left join `netapp_model_view`.`license_v2_entitlement_risk` `inventoryentitlementrisk` on(((`inventoryentitlementrisk`.`packageRaw` = `inventorylicense`.`package`) and (`inventoryentitlementrisk`.`clusterId` = `inventorylicense`.`clusterId`)))) join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventorylicense`.`clusterId`))) union select `inventorycluster`.`name` AS `clusterName`,`inventoryentitlementrisk`.`packageRaw` AS `licensePackage`,`inventorylicense`.`description` AS `licenseDecription`,`inventorylicense`.`licenseTypeRaw` AS `licenseType`,`ocum`.`na_boolToEnabledDisabled`((`inventorylicense`.`licenseTypeRaw` is not null)) AS `licenseStatus`,`inventorylicense`.`serialNumber` AS `licenseSerialNumber`,`inventorylicense`.`expirationTime` AS `licenseExpirationTime` from ((`netapp_model_view`.`license_v2_entitlement_risk` `inventoryentitlementrisk` left join `netapp_model_view`.`license` `inventorylicense` on(((`inventoryentitlementrisk`.`packageRaw` = `inventorylicense`.`package`) and (`inventorylicense`.`clusterId` = `inventoryentitlementrisk`.`clusterId`)))) join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryentitlementrisk`.`clusterId`)))