Need a report on sizes of files checked in

Document ID : KB000013607
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Need to be able to provide a BIRT report that shows what files were checked in, by whom, and how big they were, for the past week.

Environment:
x
Answer:

SELECT HARENVIRONMENT.ENVIRONMENTNAME,
HARPACKAGE.PACKAGENAME,
HARPATHFULLNAME.PATHFULLNAME,
HARITEMNAME.ITEMNAME,
HARVERSIONS.MAPPEDVERSION,
HARVERSIONDATA.DATASIZE,
to_char(HARVERSIONS.CREATIONTIME, 'MM-DD-YYYY HH:MI') CREATIONTIME,
HARUSER.USERNAME
FROM HARVERSIONS
INNER JOIN HARVERSIONDATA ON HARVERSIONS.VERSIONDATAOBJID = HARVERSIONDATA.VERSIONDATAOBJID
INNER JOIN HARITEMNAME ON HARITEMNAME.NAMEOBJID = HARVERSIONS.ITEMNAMEID
INNER JOIN HARPATHFULLNAME ON HARVERSIONS.PATHVERSIONID = HARPATHFULLNAME.VERSIONOBJID
INNER JOIN HARPACKAGE ON HARPACKAGE.PACKAGEOBJID = HARVERSIONS.PACKAGEOBJID
INNER JOIN HARENVIRONMENT ON HARENVIRONMENT.ENVOBJID = HARPACKAGE.ENVOBJID
INNER JOIN HARUSER ON HARVERSIONS.CREATORID = HARUSER.USROBJID
WHERE HARPACKAGE.PACKAGENAME <> 'BASE'
AND HARVERSIONDATA.DATASIZE > 0
AND HARVERSIONS.CREATIONTIME BETWEEN SYSDATE - 7 AND SYSDATE + 1
ORDER BY ENVIRONMENTNAME, DATASIZE DESC

Additional Information:

As always, please contact CA Technologies support for CA Harvest Software Change Manager if you have further questions.