question

jwong14 avatar image
0 Votes"
jwong14 asked olufemiaMSFT edited

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.

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

olufemiaMSFT avatar image
0 Votes"
olufemiaMSFT answered olufemiaMSFT edited

Hello @jwong14 ,

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.