CloudHealth FlexReport Historical Spend Report Configuration

Aimably Documentation > Data Integrations > CloudHealth FlexReport Historical Spend Report Configuration

The instructions below are for Aimably clients which do not have access to the AWS Billing Console, but do have access to CloudHealth. Clients may create the CUR as a CloudHealth FlexReport. Below are instructions on how to create a FlexReport containing AWS CUR data and delivering the report to Aimably for use.

Create a CUR Using the CloudHealth FlexReport

For a detailed guide to CloudHealth FlexReports, please refer to VMWare Documentation

In CloudHealth, navigate to Reports > FlexReports.

Click New Report.



 Name the report AWS Spend - 12 Month by Service/Account

Select AWS Cost & Usage Report as the Dataset

Below the Filter button, expand the Report Query section and click Edit



Update the query in the query editor with the below:

{ "sqlStatement": "SELECT timeInterval_Month AS Month, SUM(LineItem_UnblendedCost) AS

LineItem_UnblendedCost, product_ProductName AS Product_ProductName,

lineItem_UsageAccountId AS LineItem_UsageAccountId FROM AWS_CUR GROUP BY

timeInterval_Month, lineItem_UsageAccountId, product_ProductName ORDER BY Month DESC",

"needBackLinkingForTags": true,

"dataGranularity": "MONTHLY",

"timeRange": {

"last": 13,

"excludeCurrent": false

},

"limit": -1}


Click Apply

Save the report


Now on the Flex Reports page where all Flex Reports are listed locate the report you named “AWS Spend - 12 Month by Service/Account” and:



Please locate the exported report where you saved to and email it to cur@aimably.com