Flexreport to get both compute and storage for AmazonEC2

Products

• CloudHealth

Issue/Introduction

You can utilize below FlexReport query to retrieve both compute and storage for AmazonEC2

Resolution

{
  "sqlStatement": "SELECT timeInterval_Month AS Month, SUM(lineItem_UnblendedCost) AS SUM_lineItem_UnblendedCost, lineItem_ProductCode AS LineItem_ProductCode, product_productFamily AS Product_productFamily, lineItem_ResourceId AS LineItem_ResourceId, product_instanceType AS Product_instanceType, product_instanceTypeFamily AS Product_instanceTypeFamily, product_ProductName AS Product_ProductName FROM AWS_CUR WHERE (lineItem_ProductCode IN ('AmazonEC2')) AND ((product_productFamily IN ('Storage')) OR (product_productFamily IN ('Compute Instance'))) GROUP BY timeInterval_Month, lineItem_ProductCode, product_productFamily, lineItem_ResourceId, product_instanceType, product_instanceTypeFamily, product_ProductName",
  "needBackLinkingForTags": true,
  "dataGranularity": "MONTHLY",
  "timeRange": {
    "last": 12
  },
  "limit": -1
}