AnsweredAssumed Answered

Query help to show Project data.

Question asked by TomConnery on Oct 1, 2008
Latest reply on May 1, 2009 by TomConnery
What I'm trying to do is show the project manager, project code, project name, and what resources have access to the project. The reason being, we believe someone besides the manager is making changes to a project and we can't track it. Can someone assist?  So far I'm only hitting an NBI table for the project info....   not sure how to get the resource access or security info.  SELECT F.PROJECT_ID, F.PROJECT_CODE, F.PROJECT_NAME, F.MANAGER_ID, F.MANAGER_LAST_NAME, F.MANAGER_FIRST_NAME FROM NBI_PROJECT_CURRENT_FACTS F 

Outcomes