no EBS costs? about ice HOT 12 CLOSED

@ma78 Do you see EBS usages?
Can you list the EBS operations and usage types that you think should have costs but not in Ice?

Thanks
-Fang

from ice.

I seem to find inconsistencies all over the place... ie.

AWS bill for ap-southeast-2:

Amazon EC2 EBS
    $0.00 for the first 2 million I/O requests under monthly free tier  2,000,000 IOs   0.00
    $0.00 per GB-Month of snapshot data stored under monthly free tier  0.185 GB-Mo     0.00
    $0.105 per GB-Month of snapshot data stored     14.884 GB-Mo    1.56
    $0.11 per 1 million I/O requests    60,302 IOs  0.01
    $0.11 per GB-month of provisioned storage   253.495 GB-Mo   27.88

Then in ICE, when I look at ap-southeast-2 I see nothing under EBS. If i check my detailed billing file I see a stack of lines like so:

"Estimated","xxxx","xxxx","LineItem","xxxxx","Amazon Elastic Compute Cloud","xxx","xxx","xxx","APS2-EBS:VolumeUsage","CreateVolume","","N","$0.11 per GB-month of provisioned storage","2013-10-01 00:00:00","2013-10-01 01:00:00","0.01075269","0.1100000000","0.00118280","0.1100000000","0.00118280","vol-xxxx",,,,,,

When I tally all of these up, I get very close to the 27.88.

So i'm assuming ICE hasn't picked up the APS2-EBS:VolumeUsage usagetype?

I see this all over the place.. another example is RDS. ICE hasn't picked up my multi-AZ storage usage even though it's in the billing file. ie i have a stack of these:

"Estimated","xxx","xxx","LineItem","xxx","Amazon RDS Service","xxx","xxx","xxx","USW1-RDS:Multi-AZ-StorageUsage","CreateDBInstance","us-west-1","N","$0.22 per GB-month of provisioned storage for Multi-AZ deployments","2013-10-01 00:00:00","2013-10-01 01:00:00","0.00672043","0.2200000000","0.00147849","0.2200000000","0.00147849","xxx",,,,,,

Does it have anything to do with the prefix of the region in the usage type? ie. USW1-RDS:Multi-AZ-StorageUsage vs RDS:Multi-AZ-StorageUsage?

from ice.

@ma78 Please pull the latest code and re-process you data to see if it solves your problem.

Thanks
-Fang

from ice.

Yes all costs now line up perfectly!

Except for Glacier and support.

Glacier costs are not coming up:

TimedStorage-ByteHrs GlacierS3ObjectOverhead N $0.000 per GB - storage under the monthly global free tier
TimedStorage-GlacierByteHrs GlacierObjectOverhead N $0.010 per GB / month of storage used - Amazon Glacier (US)
TimedStorage-GlacierByteHrs GlacierStorage N $0.010 per GB / month of storage used - Amazon Glacier (US)

and support is not coming up either:

Productname = AWS Support (Business)

Great work!

from ice.

@ma78 Can you give me some sample line items for Glacier and support?

from ice.

the below contains usage type, operations, availabilityzone, reservedinstances, itemdescription

TimedStorage-ByteHrs GlacierS3ObjectOverhead N $0.000 per GB - storage under the monthly global free tier

do you need any other column?

from ice.

Hey fangji .. do you think it is possible to represent RI purchases in ICE?

from ice.

@ma78 A few questions:

1. Did you see usage (not cost) of TimedStorage-ByteHrs GlacierS3ObjectOverhead in Ice?
2. Did you see usage (not cost) of TimedStorage-GlacierByteHrs GlacierObjectOverhead in Ice?
   Can you let me know your usage and cost for TimedStorage-GlacierByteHrs GlacierObjectOverhead? You don't need to tell me the real number. Just make sure the usage and cost values are proportional.
3. Same question for TimedStorage-GlacierByteHrs GlacierStorage.
4. Can you give me a sample line item for AWS Support (Business)? Do you see any usages of AWS Support (Business) in Ice?

from ice.

@ma78 For your question about "represent RI purchases in ICE", check out "Reservation capacity poller" in readme page.

from ice.

Fangji I'm not talking about the ongoing cost I mean the one off costs for
RI purchases. I don't believe these are shown?
On 26/10/2013 5:08 AM, "fangji" [email protected] wrote:

@ma78 https://github.com/ma78 For your question about "represent RI
purchases in ICE", check out "Reservation capacity poller" in readme page.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/65#issuecomment-27113700
.

from ice.

@ma78 s

from ice.

@ma78 What do you mean by "one off costs for RI purchases"? Do you mean upfront cost? If that's what you mean, and you use reservation capacity poller, Ice will try to calculate amortized upfront houly cost. E.g. if the upfront cost for 3 year is $1000, then the amortized upfront hourly cost will be $1000 / (# hours in 3 year).

from ice.