Hello All,
I would like to know if it is possible to get a report of the top 100 tables that consume the most storage in our instance.
On the HI Portal, we can see this information under "Database Footprint." For our instance, I want to know if this data can be stored internally or if there is an API available to retrieve it.
I also want to automate table cleanup for these top 100 tables. The requirement is:
Whenever a table is identified as one of the top 100 in storage, a record should be created in the auto-flush setup.
Data older than 90 days should be automatically deleted every day.
Please advise if this is possible and the best way to implement it.
