Clarity PPM - Database Table for OBS
Article ID: 190744
Clarity PPM On Premise
How can I find out which OBS a Resource belongs to?
Release : 15.7
Component : CA PPM APPLICATION
The database table that links a Resource to an OBS is:
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'