View ocum_report.clusterlicensedetailview | Generated by SchemaSpy |
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`)))