Need a report to show a list of all files checked in

book

Article ID: 131341

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction



I am wanting to generate a BIRT report showing all files checked into my project in the past 90 days.  How can this be done?

Environment

Release:
Component: HCORE

Resolution

This SQL will produce the requested report:

SELECT TO_CHAR(V.MODIFIEDTIME, 'mm/dd/yyyy hh:mi:ss') AS CHECKINTIME,
    P.PACKAGENAME,
    U.USERNAME,
    PFN.PATHFULLNAME,
    ITM.ITEMNAME,
    V.MAPPEDVERSION
  FROM HARENVIRONMENT E
  INNER JOIN HARPACKAGE P ON E.ENVOBJID = P.ENVOBJID
  INNER JOIN HARVERSIONS V ON P.PACKAGEOBJID = V.PACKAGEOBJID
  INNER JOIN HARPATHFULLNAME PFN ON V.PATHVERSIONID = PFN.VERSIONOBJID
  INNER JOIN HARITEMNAME ITM ON ITM.NAMEOBJID = V.ITEMNAMEID
  INNER JOIN HARUSER U ON V.MODIFIERID = U.USROBJID
  WHERE E.ENVOBJID = ${${PROJECT_ID}
  AND V.VERSIONSTATUS = 'N'
  AND V.MODIFIEDTIME > (SysDate - 90)
  ORDER BY V.MODIFIEDTIME,
    P.PACKAGENAME,
    PFN.PATHFULLNAME,
    ITM.ITEMNAME,
    V.MAPPEDVERSION