Is there a way to extract the workflow tasks within a particular change order category?

Products

• CA Service Desk Manager

Issue/Introduction

Is there a way to extract the workflow tasks within a particular change order category?

This question raises as there is no "export" button on change order category workflow tasks tab so if other team/management would need to 

review the tasks of certain change order category to decide which ones to retain and which ones to delete, SDM administrators will need to perform some extracts and present for review.

 

 

Environment

Release : 17.1/17.2/17.3

Component : SERVICE DESK BUSINESS OBJECTS

Resolution

Please run these commands from command prompt on Service Desk server

1. pdm_extract -f "select id, sym from Change_Category where sym='the-category-name'"
    note the id from this output as you will need it in next step
2  pdm_extract -f "select sequence, task from Workflow_Task_Template where object_attrval='id-value-from-step1'" > category-task-report.txt
    this command will extract the sequence and task code to the output file. if the codes are not easy to understand, you may need to run next command
3. (optional) pdm_extract -f "select code, sym from Task_Type" > code-to-name.txt