Report for Storage consumption per Table

[jubert_t_doctor]

Hello - I am reaching out to request your assistance in generating a report that will provide visibility into the storage consumption per table within our ServiceNow instance.

The objective of this report is to help us track usage more effectively, identify high-storage tables, and support capacity management planning.

Specifically, we are looking for a report that:

• Shows storage consumption per table (ideally measured in gigabytes).
• Can be generated or tracked on a monthly basis.
• Provides a clear view of trends over time for monitoring and optimization.

Your expertise and guidance on the best approach to implement this would be greatly appreciated.

Best regards,

Jubert

[kaushal_snow]

Hi @jubert_t_doctor ,

You can use the built in sys_physical_table_stats table to pull storage usage (data + indexes) per table, optionally request a  Database Footprint report from SNOW Support for top tables, schedule a monthly job to snapshot the stats into a custom table with table name and size and date, then build a report/dashboard (in SNOW or Tableau) that shows trends month-over month / year-over year to identify high storage tables for capacity management.......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.