Using FlexReports how can we extract what egress charges are incurred in Azure?

Products

• CloudHealth

Issue/Introduction

Egress charges are grouped as part of the service that is initiating the egress data transfer.
 
This makes the specific use case of viewing egress charges difficult in this report. 

The platform has a FlexReport dataset that is designed specifically for custom reporting like this scenario.
 
Looking at how Azure reports on egress, it appears they set the Meter Category to Bandwidth in the bill - https://azure.microsoft.com/en-au/pricing/details/bandwidth/
 
If we start with a FlexReport filtered on this Meter Category, you should be able to then build a report to gather your egress dataset.
 
Sample report to get things started:

 

{
"sqlStatement": "SELECT timeInterval_Month AS Month, SUM(CostInBillingCurrency) AS SUM_CostInBillingCurrency, MeterCategory AS MeterCategory, MeterName AS MeterName, MeterSubCategory AS MeterSubCategory, ProductName AS ProductName, ConsumedService AS ConsumedService, ServiceFamily AS ServiceFamily, MeterRegion AS MeterRegion, MetricType AS MetricType FROM AZURE_COST_USAGE WHERE (MetricType LIKE '%Actual%') AND (MeterCategory LIKE '%Bandwidth%') GROUP BY timeInterval_Month, MeterCategory, MeterName, MeterSubCategory, ProductName, ConsumedService, ServiceFamily, MeterRegion, MetricType ORDER BY Month ASC, SUM_CostInBillingCurrency DESC",
"needBackLinkingForTags": true,
"dataGranularity": "MONTHLY",
"timeRange": {
"from": "2023-03",
"to": "2023-04"
},
"limit": -1
}

 
NOTE: Be sure you have the MetricType = Actual filter set to ensure the Azure Amortized metered data does not inflate pricing with the cost management dataset.
 

 

 
Adjust the Flex Report as needed, review the report, the report configuration, and test the results.