Project and Portfolio Management Practitioners Forum
cancel

Project Risk Query

SOLVED
Go to solution
Highlighted
Sevilay
Honored Contributor.

Project Risk Query

Hi,

on PPM database in which table the project risks are stored? In other words how can i find a specific project's risks with sql query?

Thanks in advance.

Any help will be much appreciated.
2 REPLIES
Jason Nichols K
Acclaimed Contributor.
Solution

Re: Project Risk Query

Project Risks are Requests, just like Projects Issues or Projects themselves. The Risks will be stored in the KCRT_REQUESTS tables with data also being stored in the KCRT_REQ_HEADER_DETAILS and potentially KCRT_REQUEST_DETAILS tables. You will need to tie them together with the KNTA_REFERENCES table.
Sevilay
Honored Contributor.

Re: Project Risk Query

Hi Jason,

i have already wrote the query.

All in all thank you very much.

Have a good day.