Report on completion of playbook tasks

[Deepthi13]

Hi Team, 

I need a report to be created on completion of playbooks as analysts closing FSC cases with out using 100% of playbook, so I got a requirement to create a report on playbook where the below mentioned image shows pending complete etc., pls guide how can I do this.

[Ankur Bawiskar]

@Deepthi13 

you can deep dive in this table "sys_pd_context" and then "sys_pd_activity_context" table

See below screenshots and you will be able to relate them with the playbook I created, the lanes and the activities under those

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Deepthi13]

@Ankur Bawiskar , Hi ankur, I think u have given correct approach but i am unable to go to next step pls guide more i am very very new to playbook also anything workspace as well. so not able to navigate.

[Ankur Bawiskar]

@Deepthi13 

simply type those table in left navigation and you can try to see if those tables are available for reporting or not

I am able to create report on sys_pd_activity_context after add that table in this property

Something like this will help you to start

I believe I have answered your question and you can enhance it further based on your requirement and developer skills.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Deepthi13]

GOt it I can see input record field on sys_pd_context table, but I cannot see on  sys_pd_activity_context like for which FSC record this pending.

Also I need FSC record is completed but playbook actions are partially left even single pending should complete in my report so i need to group by FSC record.
thats my whole requirment.  Please guide me this last I can close this requirment