How to select all the OBS assigned to a User from the database in Primavera P6 EPPM

 

 

  1. Login to ADMUSER schema and run the following query to get the user_id 

 

select user_id from admuser.users where user_name = ?

 

 

       2. Login to ADMUSER schema , pass the USER_ID  and read all the OBS assigned to the particular USER 

 

select UserObs.user_id, Obs.obs_name, UserObs.obs_id, UserObs.prof_id FROM admuser.obs Obs, 
admuser.userobs UserObs WHERE admuser.Obs.obs_id = admuser.UserObs.obs_id AND 
admuser.UserObs.user_id IN ( SELECT admuser.users.user_id FROM admuser.users
 WHERE admuser.users.user_id=? )
 order by obs_name

 

govindan How to select  all the OBS assigned to User from the database in Primavera P6
Connect me