How to reliably calculate ARN from Cost and Usage Report columns

1

We are working on building an automated parser which can read AWS Cost and Usage reports and link cost entries to respective resources. We are trying to go past two challenge -

  1. CUR doesn't provide a column for resource ARN directly
  2. If we want to calculate it ourselves, one missing info is the resource type against each service Does anyone know why these information are not included in CUR and if there is a reliable way to construct ARN from already available columns? Any info would be appreciated. Thanks.
질문됨 일 년 전616회 조회
1개 답변
0

Hello Atanu Roy,

Thank you for reaching out to us. Let me help you with your queries :

  1. CUR doesn't provide a column for resource ARN directly.

A : The Cost and Usage report does have a direct coloumn that will get you the resource ARN directly. Its called line_item_resource_id. While you created CUR first, you should click on the check box that states : include resource ids for it to show up in your CUR.

You can create a new CUR report with this feature enabled so that you can see the Resource ARN's directly. Please use document : Creating Cost and Usage Reports

profile pictureAWS
답변함 일 년 전
profile picture
전문가
검토됨 한 달 전
  • Hi Nithin,

    Thank you for responding. We have already enabled that option. However, in the format we get (we are using text/csv) there are no line_item_resource_id column. Instead we get a column named lineItem/ResourceId which only contains the resource id part (not the full ARN separated by : characters). Can you please help me out if we are missing something in the configuration?

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인