Flexreport to find savings associated to Amazon ElastiCache

Products

• CloudHealth

Issue/Introduction

You can utilize below FlexReport query to retrieve the savings associated to Amazon ElastiCache

Resolution

This report is designed using the "AWS_CUR" dataset to find the savings associated to Amazon ElastiCache Service:

{
  "sqlStatement": "SELECT timeInterval_Month AS timeInterval_Month, SUM(lineItem_UnblendedCost) AS SUM_lineItem_UnblendedCost, SUM(pricing_publicOnDemandCost) AS SUM_pricing_publicOnDemandCost, CAST((SUM(Pricing_publicOnDemandCost) - SUM(LineItem_UnblendedCost)) AS DECIMAL(18, 2)) AS Savings, lineItem_LineItemType AS LineItem_LineItemType, product_ProductName AS Product_ProductName, pricing_term AS Pricing_term FROM AWS_CUR WHERE (pricing_term IN ('OnDemand')) AND (product_ProductName LIKE '%Amazon ElastiCache%') GROUP BY timeInterval_Month, lineItem_LineItemType, product_ProductName, pricing_term ORDER BY timeInterval_Month ASC",
  "needBackLinkingForTags": true,
  "dataGranularity": "MONTHLY",
  "timeRange": {
    "last": 12
  },
  "limit": -1
}