Account usage Daily CUR Data or Hourly Data
search cancel

Account usage Daily CUR Data or Hourly Data

book

Article ID: 283463

calendar_today

Updated On:

Products

CloudHealth

Issue/Introduction

The following steps will help you determine the Cost and Usage Report data interval that is being used: 

Resolution

  1. Log in to the AWS Billing and Cost Management Console.
  2. From the left menu, select Reports.
  3. Verify that a Cost and Usage Report has been created using an Hourly interval.
  4. In the AWS Console, select Services > S3.
  5. Select the S3 bucket that stores the hourly CUR data.
  6. Within the bucket, locate the hourly CUR .csv file and download it.
  7. Open a terminal session and move to the directory where the CUR .csv is saved.
  8. Run this command to break down the CSV data in your terminal: Tail -n 2000 <filename>.csv This command outputs the last 2000 entries of your CSV file in your terminal.
  9. The beginning of each output should have the following syntax:
    • <instanceID>, <time interval>
    • Example: 2m7a5gvrrilqmkhwf5fxgfgd3ao2knj584672dzhmczoya,2017-03-06T06:00:00Z/2017-03-06T07:00:00Z
  10. Review outputs to verify that the Time Interval is progressing instead of showing T00:00:00 for all entries. If you see this behavior, you are using your Daily CUR data instead of Hourly Data.