FlexReport: AWS Savings Plan Utilization

Products

• CloudHealth

Issue/Introduction

Create a report to identify which accounts are utilizing the AWS Savings Plan benefit, and the quantity of that utilization. 

Resolution

Utilizing the FlexReport query provided below will obtain detailed information on AWS Savings Plan usage per account.

Replace ********* with Savings Plan ARN.

 

{
  "sqlStatement": "SELECT timeInterval_Month AS Month, SUM(lineItem_UnblendedCost) AS SUM_lineItem_UnblendedCost, SUM(lineItem_UsageAmount) AS SUM_lineItem_UsageAmount, SUM(savingsPlan_NetSavingsPlanEffectiveCost) AS SUM_savingsPlan_NetSavingsPlanEffectiveCost, savingsPlan_SavingsPlanARN AS SavingsPlan_SavingsPlanARN, bill_PayerAccountId AS Bill_PayerAccountId, lineItem_UsageAccountId AS LineItem_UsageAccountId, lineItem_LineItemType AS LineItem_LineItemType, SUM(savingsPlan_UnusedAmortizedUpfrontCommitmentForBillingPeriod) AS SUM_savingsPlan_UnusedAmortizedUpfrontCommitmentForBillingPeriod, lineItem_ResourceId AS LineItem_ResourceId FROM AWS_CUR WHERE (lineItem_LineItemType IN ('SavingsPlanCoveredUsage')) AND (savingsPlan_SavingsPlanARN LIKE '%********************%') GROUP BY timeInterval_Month, savingsPlan_SavingsPlanARN, bill_PayerAccountId, lineItem_UsageAccountId, lineItem_LineItemType, lineItem_ResourceId ORDER BY SUM_savingsPlan_NetSavingsPlanEffectiveCost DESC",
  "needBackLinkingForTags": true,
  "dataGranularity": "MONTHLY",
  "timeRange": {
    "last": 1,
    "excludeCurrent": true
  },
  "limit": -1
}