This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

I need to find serena cm and serena sbm datadictionary

MigrationDeletedUser over 6 years ago

i need to find serena cm and serena sbm data dictionary in order to write a query like"

SELECT
sbm.scr_number
, sbm.lead_developer
, cm.implementor
, cm.status
, sbm.status
FROM ???
WHERE lead developer IN ( ‘Will Welden’ , ‘Nicholaus Cruz’ , ‘Donald CTR Burrows’ , ‘Kim K Nguyen’ , ‘Sujani CTR Dasu’ )
AND sbm.dev_work_request=cm.dev_work_request;

0 dsheaffe over 6 years ago

Not sure about CM, but I do know that the base SBM schema document is normally in the documentation packs that are provided with each SBM release. It covers all all the standard SBM tables, and includes some guidance about how they relate to any tables created as part of your applications, but you will need to spend some time working out the actual relationships.
Cancel
Vote Up 0 Vote Down

Cancel
0 MigrationDeletedUser over 5 years ago

Hi Will

we do not publish the Dimensions CM schema but what we do have is a documented set of Published Views which can be used for reporting purposes. Details about the view contents can be found in the Reports Guide. All documentation for Dimensions CM can be found at http://help.serena.com/doc_center/doc_center.html#dcm.

In the example above you appear to want to select information about Dimensions CM Requests so the PCMS_CHDOC_DATA view would be a good starting point for this.

Vince
Cancel
Vote Up 0 Vote Down

Cancel

Menu

Dimensions CM User Discussions

Verified Answers

I need to find serena cm and serena sbm datadictionary

Resources