Flex report to retrieve Document DB details at the Instance level.
search cancel

Flex report to retrieve Document DB details at the Instance level.

book

Article ID: 378822

calendar_today

Updated On:

Products

CloudHealth

Issue/Introduction

Flex report to retrieve Document DB details at the Instance level.

Resolution

You can utilize the following Flex report query to retrieve instance level cost categorized by the usage for Document DB.

{
  "sqlStatement": "SELECT timeInterval_Month AS Month, SUM(lineItem_UnblendedCost) AS SUM_lineItem_UnblendedCost, product_ProductName AS Product_ProductName, product_productFamily AS Product_productFamily, lineItem_ResourceId AS LineItem_ResourceId FROM AWS_CUR WHERE (product_ProductName LIKE '%Amazon DocumentDB%') GROUP BY timeInterval_Month, product_ProductName, product_productFamily, lineItem_ResourceId",
  "needBackLinkingForTags": true,
  "dataGranularity": "MONTHLY",
  "timeRange": {
    "last": 3
  },
  "limit": -1
}