Cost usage monthly report per instance

Question

Hi AWS, I want to print the cost usage for individual server on monthly basis for a given Instance ID. I know Cost Explorer (previously known as CUR) is the best fit to do this task but unfortunately it prints it based on the Instance Type only. I was following this Stack overflow link https://stackoverflow.com/questions/63719507/how-can-i-find-out-cost-per-instance-per-month-on-aws and it recommends the use of cost-allocation tags in tandem with the Cost Explorer service to granularize the solution.

Can you please suggest if there is any other AWS service to accomplish this?

Answer

Cost and Usage Reports (CUR) and Cost Explorer are different tools. 
Cost Explorer may show cost by resource/InstanceID for the last two weeks or so: https://aws.amazon.com/blogs/aws-cloud-financial-management/extended-history-and-more-granular-data-available-within-aws-cost-explorer/

CUR might be a better solution for extended timelines. This is an example athena query -

```
SELECT line_item_resource_id as "Instance ID",
    SUM(line_item_unblended_cost) AS Cost
FROM cost_and_usage_report
WHERE line_item_product_code = 'AmazonEC2'
    -- AND Month = 04
    -- AND Year = 2023
    AND line_item_resource_id = '${instance_id}'
```

Answer

Hi Arjun, using the Cost Explorer, you can find the resource level cost for past 14 days only, provided resource-level data is enabled from the Billing & Cost Management Preferences for Cost Explorer. Once you enable it, apply the below filters on Cost Explorer to get the cost of an instance. Resource = EC2-Instances EC2-Instances =

Cost usage monthly report per instance

Relevant content