Is there a way to get Reservation coverage % in FlexReports?

Products

• CloudHealth

Issue/Introduction

Below Flex report query can be used to get Reservation coverage % for AWS services:

 

{
"sqlStatement": "WITH \"cxtemp_total\" AS (SELECT timeInterval_Month AS Month, lineItem_ProductCode AS LineItem_ProductCode, product_ProductName AS Product_ProductName, SUM(lineItem_UsageAmount) AS SUM_lineItem_UsageAmount FROM AWS_CUR WHERE (product_productFamily LIKE '%Instance%') GROUP BY timeInterval_Month, lineItem_ProductCode, product_ProductName), \"cxtemp_RI\" AS (SELECT timeInterval_Month AS Month, lineItem_ProductCode AS LineItem_ProductCode, product_ProductName AS Product_ProductName, SUM(lineItem_UsageAmount) AS SUM_lineItem_UsageAmount FROM AWS_CUR WHERE (product_productFamily LIKE '%Instance%') AND (savingsPlan_CoverageType LIKE '%RI%') GROUP BY timeInterval_Month, lineItem_ProductCode, product_ProductName) SELECT cxtemp_total.Month, cxtemp_total.LineItem_ProductCode, (cxtemp_RI.SUM_lineItem_UsageAmount/cxtemp_total.SUM_lineItem_UsageAmount) *100 as Coverage_Percentage FROM cxtemp_total INNER JOIN cxtemp_RI ON cxtemp_total.Month = cxtemp_RI.Month AND cxtemp_total.LineItem_ProductCode = cxtemp_RI.LineItem_ProductCode",
"needBackLinkingForTags": true,
"dataGranularity": "MONTHLY",
"timeRange": {
"from": "2023-03",
"to": "2023-04"
},
"limit": -1
}