Questions tagged with AWS Cost and Usage Report

Content language: English

Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

Calculating NetAmortisedCost via Cost and Usage Report

**Issue:** Unable to calculate netamortisedcost from Cost and Usage Report (CUR) data But AWS Cost Explorer still shows it. **Usecase:** we ingest Cost and Usage Reports (CSV files) internally into our BI system for cost management and also do few other things on top of it. We know that there are some columns in CUR which only comes when there is any savings plan or RIs applied for the corresponding aws account(s). If there are no savings plan / RIs applied, then AWS Cost explorer also should not show the netamortised cost calculation. Since it does, we want to understand how we can do the same using the data in cost and usage report. We use below SQL query to generate the netamortised cost. This has been working fine for us for some months. But for some other months this returns 0 netamortisedcost while AWS Cost explorer shows this metric. This query is for netamortisedcost calculation but is ported from wellarchitectedlabs.com for amortised cost calculation. ``` CASE WHEN (lineitemtype = 'SavingsPlanNegation') THEN 0 WHEN (lineitemtype = 'SavingsPlanUpfrontFee') THEN 0 WHEN (lineitemtype = 'SavingsPlanCoveredUsage') THEN NetSavingsPlanEffectiveCost WHEN (lineitemtype = 'SavingsPlanRecurringFee') THEN (TotalCommitmentToDate - UsedCommitment) WHEN (lineitemtype = 'DiscountedUsage') THEN NetEffectiveCost WHEN (lineitemtype = 'RIFee') THEN (NetUnusedAmortizedUpfrontFeeForBillingPeriod + NetUnusedRecurringFee) WHEN ((lineitemtype = 'Fee') AND (ReservationARN <> '')) THEN 0 ELSE NetUnblendedCost END netAmortisedCost ``` How AWS Cost Explorer is showing this cost metric even when there is no SP/RIs applied.
0
answers
0
votes
18
views
asked 2 months ago

AWS Datasync when executing a task and not finding changes to make, counts and charges Requests on an S3 Bucket when performing a verified on the directory / where N files are located ?????

Dear, a task was created in Datasync which transferred 8 files within a directory and subdirectories. My query is when reviewing the logs of the Datasync task, I observe that different requests are generated (created, transferred, verified). When executing a new Datasync task where no transfer was made because no new changes were detected, but when reviewing the task log again, I observed that the request was made on the root (verified directory /). My question is, when Datasync does not find a change to make, it makes N requests on the total number of files and directories that are already updated. Example: if I have 15,000 files updated on a bucket, and when executing a task again that does not make changes, will AWS still charge me and count for listing all the files that have already been transferred? I attach images where I only have 22 objects including directories, files and subdirectories, where 43 tasks were executed, of which 40 did not transfer files (only verified directory /), which, checking my cost manager, made about 1840 Requests (Put, Copy ,Post or List Request) to Amazon S3 ![![![Enter image description here](/media/postImages/original/IMr18LLdAzQ029NZYHaYyj6w) Enter image description here](/media/postImages/original/IM6a6FqBFvR3y9M2cc_47f3g) Enter image description here](/media/postImages/original/IM5rh_GTLaQaq5fKUyCZolkA)
1
answers
0
votes
51
views
asked 3 months ago