search

microsoft / coe-starter-kit

Other
721 stars 212 forks source link

[CoE Starter Kit - Feature]: Environment Table Storage Consumption #8120

Open leighmilbourne opened 2 months ago

leighmilbourne commented 2 months ago

Is your feature request related to a problem? Please describe.

Power Platform Admin center provides the ability to export the size of each table in an application environment. This is useful to help with analysis of any storage usage spike. It would be great to have this data available in the COE environment to allow for better monitoring and alerting to pro-actively be able to investigate storage spikes without needing to log into and download the tables each time.

Describe the solution you'd like

Option to maintain a daily record of size of selected/all tables within an environment, including a history so that monitoring and reporting can be configured to identify trends or unexpected storage spikes.

Describe alternatives you've considered

Currently I am managing a manual process requiring log in and download of the data from Power Platform admin center.

Additional context?

No response

AB#2959

Jenefer-Monroe commented 2 months ago

Hello we have considered storing information about Dataverse tables in the past but were discouraged by the number of built in ones that come for free. It would be very API and storage intensive. The information you suggest here would be an add on to that. We can place on the backlog but I dont expect it to be funded soon so if you end up doing work there feel free to share with the community.

leighmilbourne commented 2 months ago

Is there currently any way to extract the table size data via API?

On Tue, 23 Apr 2024, 11:18 pm Jenefer Monroe, @.***> wrote:

Hello we have considered storing information about Dataverse tables in the past but were discouraged by the number of built in ones that come for free. It would be very API and storage intensive. The information you suggest here would be an add on to that. We can place on the backlog but I dont expect it to be funded soon so if you end up doing work there feel free to share with the community.

— Reply to this email directly, view it on GitHub https://github.com/microsoft/coe-starter-kit/issues/8120#issuecomment-2072302362, or unsubscribe https://github.com/notifications/unsubscribe-auth/AED34QUIPHAKZPGJH4FGG6DY6ZNQRAVCNFSM6AAAAABGT2FJQWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZSGMYDEMZWGI . You are receiving this because you authored the thread.Message ID: @.***>

leighmilbourne commented 2 months ago

What built in one's are you referring to?

On Wed, 24 Apr 2024, 8:49 am Leigh Milbourne, @.***> wrote:

Is there currently any way to extract the table size data via API?

On Tue, 23 Apr 2024, 11:18 pm Jenefer Monroe, @.***> wrote:

Hello we have considered storing information about Dataverse tables in the past but were discouraged by the number of built in ones that come for free. It would be very API and storage intensive. The information you suggest here would be an add on to that. We can place on the backlog but I dont expect it to be funded soon so if you end up doing work there feel free to share with the community.

— Reply to this email directly, view it on GitHub https://github.com/microsoft/coe-starter-kit/issues/8120#issuecomment-2072302362, or unsubscribe https://github.com/notifications/unsubscribe-auth/AED34QUIPHAKZPGJH4FGG6DY6ZNQRAVCNFSM6AAAAABGT2FJQWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZSGMYDEMZWGI . You are receiving this because you authored the thread.Message ID: @.***>

Jenefer-Monroe commented 2 months ago

I'm referring to all the built in tables (Accounts, Users, etc) that come with each new environment. Unfortunately I'm unaware of how to get this data programmatically today. We can hold open for a bit though to see if others in the community have an idea.