Need a report that lists all projects for a particular department
Article ID: 113574
CA Harvest Software Change Manager - OpenMake Meister
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.
CA Harvest SCM all versions and platforms
Here is an example statement that would produce the requested report:
WHERE NOTE = 'Department A'
ORDER BY ENVIRONMENTNAME