Is there a way to get Process Names, descriptions, and other values out of Clarity and into a spreadsheet?
Release : All Supported Releases
Component : CA PPM APPLICATION
1. Here's a query that will pull the ID, Name, description, status, and mode.
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.
Here's a few communities posts on the topic of some process queries, searing in communities may provide other additional help with queries
See KB 141061 - How to search for known Clarity PPM Issues using Self Service