View ocum_report.clusterlicenseview | Generated by SchemaSpy |
View Definition:
select `inventorycluster`.`objid` AS `clusterid`,`inventoryentitlementrisk`.`objid` AS `riskObjid`,`inventorylicenseusage`.`uuid` AS `nodeUsageuuid`,`inventorycluster`.`name` AS `clusterName`,`inventorylicense`.`licenseTypeRaw` AS `licenseType`,`inventorylicense`.`package` AS `licensePackage`,`inventorylicense`.`expirationTime` AS `licenseExpirationTime`,`inventorylicense`.`serialNumber` AS `licenseSerialNumber`,`inventoryentitlementrisk`.`risk` AS `risk`,`inventoryentitlementrisk`.`actionCodeRaw` AS `actionCode`,`inventorylicenseusage`.`inUse` AS `inUsage`,`inventorylicenseusage`.`isLicensed` AS `nodeLockedLicense`,`inventorylicenseusage`.`nodeName` AS `nodeName`,`inventorylicenseusage`.`serialNumber` AS `nodeSerialNumber`,`inventorylicense`.`ownerName` AS `ownerName`,`inventorylicense`.`ownerType` AS `ownerType`,`inventorylicense`.`description` AS `licenseDecription`,`inventoryentitlementrisk`.`action` AS `actionDecription` from (((`netapp_model_view`.`license_v2_entitlement_risk` `inventoryentitlementrisk` join `netapp_model_view`.`node_license_usage` `inventorylicenseusage` on((`inventorylicenseusage`.`licenseV2EntitlementRiskId` = `inventoryentitlementrisk`.`objid`))) join `netapp_model_view`.`license` `inventorylicense` on(((`inventoryentitlementrisk`.`packageRaw` = `inventorylicense`.`package`) and (`inventorylicense`.`clusterId` = `inventoryentitlementrisk`.`clusterId`) and (`inventorylicense`.`ownerNodeId` = `inventorylicenseusage`.`nodeId`)))) join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventorylicense`.`clusterId`))) union select `inventorycluster`.`objid` AS `clusterid`,`inventoryentitlementrisk`.`objid` AS `riskObjid`,NULL AS `nodeUsageuuid`,`inventorycluster`.`name` AS `clusterName`,`inventorylicense`.`licenseTypeRaw` AS `licenseType`,`inventorylicense`.`package` AS `licensePackage`,`inventorylicense`.`expirationTime` AS `licenseExpirationTime`,`inventorylicense`.`serialNumber` AS `licenseSerialNumber`,`inventoryentitlementrisk`.`risk` AS `risk`,`inventoryentitlementrisk`.`actionCodeRaw` AS `actionCode`,'NA' AS `inUsage`,'NA' AS `nodeLockedLicense`,NULL AS `nodeName`,NULL AS `nodeSerialNumber`,`inventorylicense`.`ownerName` AS `ownerName`,`inventorylicense`.`ownerType` AS `ownerType`,`inventorylicense`.`description` AS `licenseDecription`,`inventoryentitlementrisk`.`action` AS `actionDecription` from ((`netapp_model_view`.`license` `inventorylicense` left join `netapp_model_view`.`license_v2_entitlement_risk` `inventoryentitlementrisk` on(((`inventoryentitlementrisk`.`packageRaw` = `inventorylicense`.`package`) and (`inventorylicense`.`clusterId` = `inventoryentitlementrisk`.`clusterId`)))) join `netapp_model_view`.`cluster` `inventorycluster` on(((`inventorycluster`.`objid` = `inventorylicense`.`clusterId`) and (`inventorylicense`.`ownerType` in ('CLUSTER','UNKNOWN'))))) union select `inventorycluster`.`objid` AS `clusterid`,`inventoryentitlementrisk`.`objid` AS `riskObjid`,NULL AS `nodeUsageuuid`,`inventorycluster`.`name` AS `clusterName`,NULL AS `licenseType`,`inventoryentitlementrisk`.`packageRaw` AS `licensePackage`,NULL AS `licenseExpirationTime`,NULL AS `licenseSerialNumber`,`inventoryentitlementrisk`.`risk` AS `risk`,`inventoryentitlementrisk`.`actionCodeRaw` AS `actionCode`,NULL AS `inUsage`,NULL AS `nodeLockedLicense`,NULL AS `nodeName`,NULL AS `nodeSerialNumber`,NULL AS `ownerName`,NULL AS `ownerType`,NULL AS `licenseDecription`,`inventoryentitlementrisk`.`action` AS `actionDecription` from ((`netapp_model_view`.`license_v2_entitlement_risk` `inventoryentitlementrisk` left join `netapp_model_view`.`license` `inventorylicense` on((`inventoryentitlementrisk`.`packageRaw` = `inventorylicense`.`package`))) join `netapp_model_view`.`cluster` `inventorycluster` on((`inventorycluster`.`objid` = `inventoryentitlementrisk`.`clusterId`))) where (`inventoryentitlementrisk`.`risk` in ('UNLICENSED','UNKNOWN'))
Possibly Referenced Tables/Views: