Detail CSV download of daily cost for all resource groups in a subscription, by date. by resource groups. by service type , by daily cost, per line.

John Wong 1 Reputation point
2021-05-07T16:36:15.703+00:00

Hello. I want to get an Excel / CSV download of detail cost breakdown in a subscription. The report will be by date, by resource groups, by service type, and the cost. In Cost Analysis, one can get a CSV download by date, by resource groups and the cost per day. One can get a CSV download by resource groups, by service type, by cumulative cost . One can go to resource groups view, click on one resource group, and get a CSV download on that resource group, by date, by service type, and the cost per day. If I have 100 resource groups to manage, then I will need to click each one of the 100 resources groups, one at a time, and download 100 CSV files.
How do I get a complete detail Excel / CSV download, of all resource groups in a subscription, by date, by resource groups, by service type, and the cost per day?
Please help with solutions that are within Azure. That is, I do not have access to external tools such as CloudChkr.

Thanks,

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
1,853 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. olufemia-MSFT 2,861 Reputation points
    2021-05-12T21:51:37.467+00:00

    Hello @John Wong ,

    If I understand correctly, you are trying to automate the collection of cost breakdown by sub/resource group/ resources for over 100 subscription. If yes, then sounds like you need a scalable solution or script. I suggest exploring Cost management REST API or PowerShell module. You may need Enterprise level Agreement to consume the REST API operations but this equally possible with the PS module.

    Let me know if this is what you are looking for. Happy to assist further.

    Cheers.

    0 comments No comments