CUR query to get Elasticache resources and instance type across payer
0
folks, struggling to get instance family being used for Elasticache across Payer, I tried few combination of CUR queries to no avail. Does anyone have a tested reference to get the information? TIA
질문됨 한 달 전157회 조회
1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
SELECT line_item_usage_account_id, product_servicename, Month, Product_region_code, line_item_line_item_type, line_item_resource_id, sum(line_item_unblended_cost) as Cost FROM "customer_cur_data"."customer_all" where And (year='2024' and month in ('xx','yy')) AND line_item_line_item_type NOT IN ('Tax','Refund','Credit','EDPDiscount') and product_servicename='Amazon ElastiCache' group by 1, 2,3,4,5,6
Modify this query to select appropriate year and Month if required
답변함 한 달 전
관련 콘텐츠
AWS 공식업데이트됨 2년 전
