Identify current global template on the Database

[Carolina]

We are trying to integrate Project Server database with other application, we
need to query the project filter by some enterprise fields (like customer or
status). It is created at the Globla template, so if we change some fileds
data a new global template is saved and our query does not work. Is there any
way to identify the current global template?

Thanks in advance for your help.
Carolina.

 

[Jonathan Yong]

Use the following SQL:

select proj_id, proj_name from msp_projects where proj_type=2