Calculating database space for a project or repository

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

Harvest Software Change Manager all versions

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.