Need a report that lists all projects for a particular department

Document ID : KB000113574
Last Modified Date : 11/09/2018
Show Technical Document Details
Introduction:
My departments are identified by a code entered into the "Note" field for each project. I need to get a report that lists only the names of all projects for a particular department.
Environment:
CA Harvest SCM all versions and platforms
Instructions:
Here is an example statement that would produce the requested report:
 SELECT ENVIRONMENTNAME
 FROM HARENVIRONMENT
 WHERE NOTE = 'Department A'
 ORDER BY ENVIRONMENTNAME