The instructions below are for Aimably clients or MSPs which do not have access to the AWS Billing Console, but do have access to CloudHealth. CloudHealth users may create the CUR as a CloudHealth Flex Report. Below are instructions on how to create a Flex Report containing AWS CUR data and delivering the report to Aimably for use.
Create a CUR using the CloudHealth FlexReport (VMWare Aria Cost - Flex Reports)
● 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:
● 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
● Please locate the exported report where you saved to and email it to cur@aimably.com