search

Azure / azure-rest-api-specs

The source for REST API specifications for Microsoft Azure.
MIT License
2.61k stars 5.02k forks source link

Get consumption data API - The consumed quantity didn't match with the v1 usage report #3553

Open jackting73 opened 6 years ago

jackting73 commented 6 years ago

Following with the document: https://msdn.microsoft.com/en-us/library/azure/mt219001 SubscriptionType: PAYG Billingcycle: 12th to 11th every month

=Issue Description= From the v1 usage report, there are two parts: the up-side is the total consumed quantity by sub-category this month, and the down-side is the daily consumed quantity. That means by sum of the daily consumed quantity will be equals to the total consumed quantity. However, we found the the response of daily consumed from API is not totally match with the v1 usage daily report, then the monthly consumed will also not match.

=Sample Request= https://management.azure.com/subscriptions/{subscription-Id}/providers/Microsoft.Commerce/UsageAggregates?api-version=2015-06-01-preview&reportedStartTime=2018-05-12T00%3a00%3a00%2b00%3a00&reportedEndTime=2018-06-12T00%3a00%3a00%2b00%3a00&aggregationGranularity=Daily&showDetails=false

=Partial Response= { "name": "Daily_BRSDT_20180512_0000", "type": "Microsoft.Commerce/UsageAggregate", "properties": { "usageStartTime": "2018-05-11T00:00:00+00:00", "usageEndTime": "2018-05-12T00:00:00+00:00", "meterName": "IP Address Hours", "meterCategory": "Networking", "meterSubCategory": "Reserved IP", "unit": "Hours", "meterId": "26ce34b7-67b3-480d-9d1b-54a7fb80f67a", "infoFields": {}, "quantity": 6.5999999999999994 } }, { "name": "Daily_BRSDT_20180512_0000", "type": "Microsoft.Commerce/UsageAggregate", "properties": { "usageStartTime": "2018-05-11T00:00:00+00:00", "usageEndTime": "2018-05-12T00:00:00+00:00", "meterName": "IP Address Hours", "meterCategory": "Networking", "meterSubCategory": "Reserved IP", "unit": "Hours", "meterId": "26ce34b7-67b3-480d-9d1b-54a7fb80f67a", "infoFields": {}, "quantity": 5.79999999999999947 } }, The above response from API show the consumed quantity on 2018-05-11 of Reserved IP was 6.59999 + 5.79999 = 12.399

=V1 Usage Report= The consumed quantity show on usage report on 2018-05-11 is 21.2 https://vmtestdiag0703.blob.core.windows.net/reservedip/reservedip.PNG

=Question= Is there any old API version can be used to get the same consumed quantity with v1 usage report ? Or any workaround to make the total consumed quantity same with the v1 usage report? Thanks.

jackting73 commented 6 years ago

Hi @sergey-shandar

Any idea no this ?

Thanks,

ghost commented 3 years ago

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @amberbhargava, @shilpigautam, @ramaganesan-rg, @anand-rengasamy.

Issue Details
Following with the document: https://msdn.microsoft.com/en-us/library/azure/mt219001 SubscriptionType: PAYG Billingcycle: 12th to 11th every month =Issue Description= From the v1 usage report, there are two parts: the up-side is the total consumed quantity by sub-category this month, and the down-side is the daily consumed quantity. That means by sum of the daily consumed quantity will be equals to the total consumed quantity. However, we found the the response of daily consumed from API is not totally match with the v1 usage daily report, then the monthly consumed will also not match. =Sample Request= https://management.azure.com/subscriptions/{subscription-Id}/providers/Microsoft.Commerce/UsageAggregates?api-version=2015-06-01-preview&reportedStartTime=2018-05-12T00%3a00%3a00%2b00%3a00&reportedEndTime=2018-06-12T00%3a00%3a00%2b00%3a00&aggregationGranularity=Daily&showDetails=false =Partial Response= { "name": "Daily_BRSDT_20180512_0000", "type": "Microsoft.Commerce/UsageAggregate", "properties": { "usageStartTime": "2018-05-11T00:00:00+00:00", "usageEndTime": "2018-05-12T00:00:00+00:00", "meterName": "IP Address Hours", "meterCategory": "Networking", "meterSubCategory": "Reserved IP", "unit": "Hours", "meterId": "26ce34b7-67b3-480d-9d1b-54a7fb80f67a", "infoFields": {}, "quantity": **6.5999999999999994** } }, { "name": "Daily_BRSDT_20180512_0000", "type": "Microsoft.Commerce/UsageAggregate", "properties": { "usageStartTime": "2018-05-11T00:00:00+00:00", "usageEndTime": "2018-05-12T00:00:00+00:00", "meterName": "IP Address Hours", "meterCategory": "Networking", "meterSubCategory": "Reserved IP", "unit": "Hours", "meterId": "26ce34b7-67b3-480d-9d1b-54a7fb80f67a", "infoFields": {}, "quantity": **5.79999999999999947** } }, The above response from API show the consumed quantity on 2018-05-11 of Reserved IP was 6.59999 + 5.79999 = **12.399** =V1 Usage Report= The consumed quantity show on usage report on 2018-05-11 is **21.2** https://vmtestdiag0703.blob.core.windows.net/reservedip/reservedip.PNG =Question= Is there any old API version can be used to get the same consumed quantity with v1 usage report ? Or any workaround to make the total consumed quantity same with the v1 usage report? Thanks.
Author: jackting73
Assignees: sergey-shandar
Labels: `Billing`, `Service Attention`
Milestone: -
ghost commented 3 years ago

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @ms-premp.

Issue Details
Following with the document: https://msdn.microsoft.com/en-us/library/azure/mt219001 SubscriptionType: PAYG Billingcycle: 12th to 11th every month =Issue Description= From the v1 usage report, there are two parts: the up-side is the total consumed quantity by sub-category this month, and the down-side is the daily consumed quantity. That means by sum of the daily consumed quantity will be equals to the total consumed quantity. However, we found the the response of daily consumed from API is not totally match with the v1 usage daily report, then the monthly consumed will also not match. =Sample Request= https://management.azure.com/subscriptions/{subscription-Id}/providers/Microsoft.Commerce/UsageAggregates?api-version=2015-06-01-preview&reportedStartTime=2018-05-12T00%3a00%3a00%2b00%3a00&reportedEndTime=2018-06-12T00%3a00%3a00%2b00%3a00&aggregationGranularity=Daily&showDetails=false =Partial Response= { "name": "Daily_BRSDT_20180512_0000", "type": "Microsoft.Commerce/UsageAggregate", "properties": { "usageStartTime": "2018-05-11T00:00:00+00:00", "usageEndTime": "2018-05-12T00:00:00+00:00", "meterName": "IP Address Hours", "meterCategory": "Networking", "meterSubCategory": "Reserved IP", "unit": "Hours", "meterId": "26ce34b7-67b3-480d-9d1b-54a7fb80f67a", "infoFields": {}, "quantity": **6.5999999999999994** } }, { "name": "Daily_BRSDT_20180512_0000", "type": "Microsoft.Commerce/UsageAggregate", "properties": { "usageStartTime": "2018-05-11T00:00:00+00:00", "usageEndTime": "2018-05-12T00:00:00+00:00", "meterName": "IP Address Hours", "meterCategory": "Networking", "meterSubCategory": "Reserved IP", "unit": "Hours", "meterId": "26ce34b7-67b3-480d-9d1b-54a7fb80f67a", "infoFields": {}, "quantity": **5.79999999999999947** } }, The above response from API show the consumed quantity on 2018-05-11 of Reserved IP was 6.59999 + 5.79999 = **12.399** =V1 Usage Report= The consumed quantity show on usage report on 2018-05-11 is **21.2** https://vmtestdiag0703.blob.core.windows.net/reservedip/reservedip.PNG =Question= Is there any old API version can be used to get the same consumed quantity with v1 usage report ? Or any workaround to make the total consumed quantity same with the v1 usage report? Thanks.
Author: jackting73
Assignees: -
Labels: `Billing`, `Consumption`, `Service Attention`
Milestone: -
ShilpiGautam commented 2 years ago

@adwise3 can you please take it fwd to the right team owning this in ACM?