CloudHealth FlexReport Historical Spend Report Configuration for AWS

 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:

• Click on the three dot menu to the left of the report name

• Choose the Run Report option - as you cannot export unrun reports

• Once the report is run you will see Report Status updated to Completed and the Last Run date will be

• current

• Click on the three dot menu to the left of the report name again

• Click Export