1 Answer
- Newest
- Most votes
- Most comments
0
Hi you can use following query Athena CUR query
SELECT
bill_payer_account_id,
line_item_usage_account_id,
line_item_operation,
line_item_resource_id,
product_product_family,
product_servicename,
line_item_line_item_description,
pricing_unit,
resource_tags_user_name,
year,
month,
line_item_unblended_rate,
sum(line_item_usage_amount) as Usage,
sum(line_item_unblended_cost) as Cost
FROM
"customer_cur_data"."customer_all"
where
line_item_operation = 'VpcEndpoint'
AND bill_payer_account_id in ('')
and year='2023' and month in ('04')
AND line_item_line_item_type NOT IN ('Tax','Refund','Credit')
AND product_servicename = 'Amazon Virtual Private Cloud'
group by 1,2,3,4,5,6,7,8,9,10,11,12
replace with actual account numbers and months. Download results and then you will get account wise resource with bytes transferred and usage hours. "VpcEndpoint-Bytes" represents data processed
answered 4 months ago
Relevant content
- asked 6 years ago
- Accepted Answerasked 2 years ago
- Accepted Answerasked 6 months ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 7 months ago
Thanks you Kiran.. didnt expect to get the response so quickly. Amazing. this work flawlessly. Thanks you so. much.