densify

Tables (4)

densify_account_info (densify 전체 account정보)

  • aws/azure (csp) — Primary key — NOT NULL — value - aws - azure - container
  • accountId from densify (accountId) — Primary key — NOT NULL
  • mcmp customerId (customerId) — Primary key — NOT NULL
  • densify 연동 여부 (activeYn)
  • 최초수집시간 (regDate)
  • 마지막업데이트시간 (modDate)

densify_recommend_cloud (aws, azure 추천 결과)

  • 046492796127 (accountId) — Primary key — NOT NULL
  • entityId — Primary key — NOT NULL
  • 179.58 (currentCost)
  • 0.25 (currentHourlyRate)
  • t2.small (currentType)
  • SKCC AWS Policy (densifyPolicy)
  • Moderate (effortEstimate)
  • wh-tcmspap1 (name)
  • Linux (osName)
  • Running (powerState)
  • 95.35 (predictedUptime)
  • Downsize - Optimal Family (recommendationType)
  • 75.92 (recommendedCost)
  • entityId (recommendedHostEntityId)
  • 0.1 (recommendedHourlyRate)
  • c5.large (recommendedType)
  • ap-northeast-2 (region)
  • Field12 (resourceId)
  • 103.66 (savingsEstimate)
  • EC2/RDS/ASG/SPOT (serviceType)
  • 840 (totalHoursRunning)
  • 처음 추천된 시간 (recommFirstSeen)
  • 마지막으로 추천된 시간 (recommLastSeen)
  • 기간동안 추천된 횟수 (recommSeenCount)

densify_recommend_cloud_detail (Untitled)

    densify_recommend_container (container 추천 결과)

    • mcmp customerId (customerId) — Primary key — NOT NULL
    • entityId — Primary key — NOT NULL