FlexReport query to view Azure Unused Savings Plan

Products

• CloudHealth

Issue/Introduction

How to view Azure Unused Savings Plan in FlexReports?

Resolution

{
  "sqlStatement": "SELECT timeInterval_Month AS Month, PricingModel AS PricingModel, SUM(CostInReportingCurrency) AS SUM_CostInReportingCurrency, ChargeType AS ChargeType FROM AZURE_COST_USAGE WHERE (ChargeType IN ('UnusedSavingsPlan')) AND (PricingModel IN ('SavingsPlan')) GROUP BY timeInterval_Month, PricingModel, ChargeType ORDER BY Month ASC",
  "needBackLinkingForTags": true,
  "dataGranularity": "MONTHLY",
  "timeRange": {
    "last": 12
  },
  "limit": -1
}