Clarity PPM - Database Table for OBS
Article ID: 190744
Updated On:
Products
Clarity PPM On Premise
Issue/Introduction
How can I find out which OBS a Resource belongs to?
Environment
Release : 15.7
Component : CA PPM APPLICATION
Resolution
The database table that links a Resource to an OBS is:
prj_obs_associations
The "RECORD_ID" value matches the ID from the SRM_RESOURCES table
The "UNIT_ID" value matches the OBS ID from the prj_obs_units database table.
One thing to be aware of, this table stores the association of many objects to the OBS. If you want to filter further, you can use:
select * from prj_obs_associations where TABLE_NAME = 'SRM_RESOURCES'
prj_obs_associations
The "RECORD_ID" value matches the ID from the SRM_RESOURCES table
The "UNIT_ID" value matches the OBS ID from the prj_obs_units database table.
One thing to be aware of, this table stores the association of many objects to the OBS. If you want to filter further, you can use:
select * from prj_obs_associations where TABLE_NAME = 'SRM_RESOURCES'
Feedback
Yes
No
Powered by
