Is there a way to Query / Export a list of Processes in Clarity?

Products

• Clarity PPM On Premise

Issue/Introduction

Is there a way to get Process Names, descriptions, and other values out of Clarity and into a spreadsheet? 

Environment

Release : All Supported Releases

Component : CA PPM APPLICATION

Resolution

1. Here's a query that will pull the ID, Name, description, status, and mode.

• Status = Indicates whether the process has been validated 
• Mode = Indicates whether process is in draft, active, on hold 

select
bdp.id  process_id,
ccn.name process_name,
ccn.description Description,
bdpv.user_status_code Process_Mode,
bdpv.Internal_Status_Code Status
from bpm_def_processes  bdp
 inner join bpm_def_process_versions bdpv on bdp.id =  bdpv.process_id
 inner join cmn_captions_nls ccn on  bdp.id = ccn.pk_id
   and ccn.table_name = 'BPM_DEF_PROCESSES'
   and ccn.language_code = 'en'
 inner join bpm_def_stages bdsa on bdpv.id = bdsa.process_version_id

2. The data can then be copied into a spreadsheet from the query output. 

3. See also Clarity PPM Advanced Reporting and Database Schema Index for more assistance if additional fields are needed or a different query is needed. 

Additional Information

 

Here's a few communities posts on the topic of some process queries, searing in communities may provide other additional help with queries

• https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=752581 
• https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=725306
• https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=721989

See KB 141061 - How to search for known Clarity PPM Issues using Self Service