How much database space is my project or repository using?
book
Article ID: 198971
calendar_today
Updated On:
Products
CA Harvest Software Change ManagerCA Harvest Software Change Manager - OpenMake Meister
Issue/Introduction
We would like to clean up our Harvest database and possibly archive some projects to reclaim space. Is there a query that will show how much space in the Harvest database a particular project or repository is using?
Environment
Release : 13.0.3
Component : CA Harvest Software Change Manager
Resolution
Attached are 2 txt files containing SQL queries for this. One of the files has a SQL Server version of the queries and the other has the Oracle version of the queries.
Attachments
1600437271167__repository size and project size queries Oracle.txtget_app
1600437257722__repository size and project size queries SQL Server.txtget_app