2

In AWS billing (bill file name is accountid-aws-billing-detailed-line-items-with-resources-and-tags-year-month.csv) there is a column "PricingPlanId", Is there any API or SDK support to query info related to the corresponding Pricing plan?

slm
  • 15,396
  • 12
  • 109
  • 124
sreekanth guru
  • 31
  • 2
  • What are some example values you see in `PricingPlanId`? It may have a different name, elsewhere. – Michael - sqlbot Apr 06 '17 at 11:58
  • It's a 7 digit integer(like 1422569). I assume aws maps this number to some plan internally. In case of vm ran as reserved instance it's pricing plan id is matching with the, reserved instance purchase planId. Example: Sign up charge for subscription: 455087981, planId: 1422569 – sreekanth guru Apr 06 '17 at 13:04
  • please add more details. – ketan vijayvargiya Apr 06 '17 at 18:59
  • okay. My use case is I want to find the true cost of a vm instance. Suppose if it was run as reserved instance for some hours then it's cost is zero for those hours(not considering partial hours, etc.). But in actual I have paid the bill for those hours as part of reserved instance. So I am trying to calculate the cost for those hours from reserved instances billing. If there are multiple matching reserved instance plans(purchased by user) then which RI plan was used for the vm is unknown. I need help in mapping the pricing plan id to Reserved instance. Thank You. – sreekanth guru Apr 07 '17 at 05:58
  • A line from my aws bill(some fields are masked) - InvoiceID(Estimated) PayerAccountId(*) ProductName(Amazon EC2) RateId(18118386) SubscriptionId(455087981) PricingPlanId(455087981) UsageType(USW2-BoxUsage:t2.micro) Operation(RunInstances) ReservedInstance(Y) ItemDescription(USD 0.0 per Linux/UNIX (Amazon VPC), t2.micro instance-hour (or partial hour)) BlendedRate(0) BlendedCost(0) UnBlendedCost(0) ResourceId(i-xxx) - I am trying to map PricingPlanId to some reserved instance plan. Please let me know if there is any other way to get the actual cost of vm (including the reserved instance cost). – sreekanth guru Apr 07 '17 at 06:05
  • Hi, Any update on this?. Thank you. – sreekanth guru Apr 10 '17 at 07:32

0 Answers0