Finding unused repositories

Products

• CA Harvest Software Change Manager - OpenMake Meister
• CA Harvest Software Change Manager

Issue/Introduction

Need a query that will identify repositories which are not attached to any projects.

Environment

Harvest Software Change Manager

Resolution

All repositories have at least one view, even if not baselined into a project. This will provide the requested information

(works with Oracle and with SQL Server)

SELECT REPOSITOBJID, REPOSITNAME 
FROM HARREPOSITORY 
WHERE REPOSITOBJID NOT IN 
(SELECT DISTINCT HARREPINVIEW.REPOSITOBJID 
FROM HARVIEW 
INNER JOIN HARREPINVIEW 
ON HARVIEW.VIEWOBJID = HARREPINVIEW.VIEWOBJID 
WHERE HARVIEW.VIEWNAME = 'baselineview') 
AND REPOSITOBJID > 0