How do I know which template was a project created or copied from?

Products

• Clarity PPM On Premise

Issue/Introduction

I want to know which project templates have been used to create the existing projects. How can I know what is the template used?

Environment

Release: All Supported Releases
Component: Clarity PPM Project Management

Resolution

Here is a query to identify the internal ID of a template from which a project has been created or copied from:

select templ.code copiedFrom, copied.code copiedTo, flat.created_by copiedBy, flat.created_date copiedDate

from odf_object_copy_flat flat, inv_investments templ, inv_investments copied

where flat.src_object_id = templ.id

and flat.object_code = 'project'

and flat.object_id = copied.id