View ocum_report.clusterlicenseview 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
clusterid bigint 19 0
riskObjid bigint 19  √  null
nodeUsageuuid varchar 255  √  null
clusterName varchar 255
licenseType varchar 255  √  null
licensePackage varchar 255  √  null
licenseExpirationTime timestamp 19  √  null
licenseSerialNumber varchar 255  √  null
risk varchar 10  √  null
actionCode varchar 255  √  null
inUsage varchar 4  √  null
nodeLockedLicense varchar 4  √  null
nodeName varchar 255  √  null
nodeSerialNumber varchar 255  √  null
ownerName varchar 255  √  null
ownerType varchar 7  √  null
licenseDecription varchar 255  √  null
actionDecription varchar 255  √  null

Analyzed at Tue Apr 23 04:52 EDT 2019

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: