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?

David · 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}'
```

Sanjay Rajhans · 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