search cancel

Used Space Reports

book

Article ID: 200223

calendar_today

Updated On:

Products

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

Issue/Introduction

Is there a report that shows an even more detailed breakdown of what is taking up space in each repository?

Environment

Release : 13.0.3

Component : CA Harvest Software Change Manager

Resolution

To get a list of which files are taking the most space, this query might help:

SELECT DISTINCT HARENVIRONMENT.ENVIRONMENTNAME,
  HARREPOSITORY.REPOSITNAME,
  HARPACKAGE.PACKAGENAME,
  HARVERSIONS.VERSIONOBJID,
  HARPATHFULLNAME.PATHFULLNAME,
  HARITEMNAME.ITEMNAME,
  HARVERSIONS.MAPPEDVERSION,
  HARVERSIONDATA.DATASIZE
FROM HARENVIRONMENT
INNER JOIN HARVIEW ON HARENVIRONMENT.ENVOBJID = HARVIEW.ENVOBJID
INNER JOIN HARVERSIONINVIEW ON HARVIEW.VIEWOBJID = HARVERSIONINVIEW.VIEWOBJID
INNER JOIN HARVERSIONS ON HARVERSIONS.VERSIONOBJID = HARVERSIONINVIEW.VERSIONOBJID
INNER JOIN HARVERSIONDATA ON HARVERSIONS.VERSIONDATAOBJID = HARVERSIONDATA.VERSIONDATAOBJID
INNER JOIN HARPATHFULLNAME ON HARVERSIONS.PATHVERSIONID = HARPATHFULLNAME.VERSIONOBJID
INNER JOIN HARITEMNAME ON HARITEMNAME.NAMEOBJID = HARVERSIONS.ITEMNAMEID
INNER JOIN HARPACKAGE ON HARPACKAGE.PACKAGEOBJID = HARVERSIONS.PACKAGEOBJID
INNER JOIN HARITEMS ON HARVERSIONS.ITEMOBJID = HARITEMS.ITEMOBJID
INNER JOIN HARREPOSITORY ON HARITEMS.REPOSITOBJID = HARREPOSITORY.REPOSITOBJID
WHERE HARENVIRONMENT.ENVOBJID > 0
AND HARVERSIONDATA.DATASIZE > 1000000  /* <--- threshold data size */
ORDER BY HARVERSIONDATA.DATASIZE DESC,
  HARREPOSITORY.REPOSITNAME,
  HARENVIRONMENT.ENVIRONMENTNAME,
  HARPACKAGE.PACKAGENAME,
  HARPATHFULLNAME.PATHFULLNAME,
  HARITEMNAME.ITEMNAME