Hello fellow Dynamics devs and admins,
I've been tasked by management to come up with a way of sending out a report on a bi-weekly basis, that shows a small number of users, how much environment storage is being used versus the available capacity.
I have power platform admin, so am one of the few people in my company who have visbility of the graph showing capacity and usage for log, file and database.
Having said that, I think all we would need is the ability to export the values for a specific number of databases, versus the capacity, OR ideally the summary statistics from that dashboard would be perfect, ie the bar graph where it shows you the capacity versus storage used for each of those three types.
I've looked long and hard online to find a method, and found these two.
This first one would seem to be the most likely to succeed, as it's an MS article, and is very recent (1 month since last update) although admittedly still in preview:
https://learn.microsoft.com/en-us/power-platform/admin/programmability-tutorial-create-daily-capacity-report?tabs=Azure
Admittedly a fair chunk of it is somewhat over my head, and I've tried the power automate route, and not gotten very far, it does seem to suggest power apps should be fine, but so far I have had no success.
I have also tried the Azure and powershell routes (Further down the guide) but run into issues each time.
The second likely candidate I found was this one:
https://www.blog.allandecastro.com/leverage-the-power-platform-api-to-create-a-capacity-report/
It's reasonably detailed, but alas not a step by step guide - someone in the comments asked if he might consider creating a video guide, which he said he was considering.
Evidently my knowledge is not sufficient to complete this task from these two guides, so I was just wondering if anyone had managed to go through either of these methods, or found another way entirely, and managed to make it work for them and their company?
Thanks in hopefulness!
BD
Share
Report
All responses (
Answers (
98
