Flexreport to see the extended support data associated to all services

Products

• CloudHealth

Issue/Introduction

You can utilize below FlexReport query to retrieve the extended support data associated to all services for the last 12 months

Resolution

{
  "sqlStatement": "SELECT timeInterval_Month AS Month, SUM(lineItem_UnblendedCost) AS SUM_lineItem_UnblendedCost, lineItem_ProductCode AS LineItem_ProductCode, product_ProductName AS Product_ProductName, SUM(lineItem_UsageAmount) AS SUM_lineItem_UsageAmount, pricing_unit AS Pricing_unit, lineItem_UsageType AS LineItem_UsageType, lineItem_LineItemDescription AS LineItem_LineItemDescription FROM AWS_CUR WHERE ((lineItem_UsageType LIKE '%extended%') OR (lineItem_UsageType LIKE '%Extended%')) GROUP BY timeInterval_Month, lineItem_ProductCode, product_ProductName, pricing_unit, lineItem_UsageType, lineItem_LineItemDescription ORDER BY Month ASC",
  "needBackLinkingForTags": true,
  "dataGranularity": "MONTHLY",
  "timeRange": {
    "last": 12
  },
  "limit": -1
}