Allow end user to see project baseline snapshot name

Document ID : KB000117198
Last Modified Date : 09/10/2018
Show Technical Document Details
Introduction:
My developers need to know from which snapshot was the baseline for their project taken.  Workbench will only show the name of the repository.  Is there a query that can provide this information?
Environment:
CA Harvest SCM all versions and platforms
Instructions:
This query will answer the question:

SELECT HARENVIRONMENT.ENVIRONMENTNAME,
  HARVIEW.VIEWNAME,
  HARVIEW.VIEWTYPE
FROM HARENVIRONMENT
INNER JOIN HARREPINVIEW ON HARENVIRONMENT.BASELINEVIEWID = HARREPINVIEW.VIEWOBJID
INNER JOIN HARVIEW ON HARVIEW.VIEWOBJID = HARREPINVIEW.REPFROMVIEWID
WHERE HARENVIRONMENT.ENVIRONMENTNAME = 'SampleProject' /* <--- Project Name goes here */