search cancel

Clarity PPM - Database Table for OBS

book

Article ID: 190744

calendar_today

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'