ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How much database space is my project or repository using?

book

Article ID: 198971

calendar_today

Updated On:

Products

CA Harvest Software Change Manager CA 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.txt get_app
1600437257722__repository size and project size queries SQL Server.txt get_app