Finding project baseline's snapshot name

Products

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

Issue/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

Resolution

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 */

Additional Information

More information on what a snapshot is in Harvest and how it can be used is found here: Understand Projects and Lifecycles - Snapshot Views