How to report on KB articles that are under "Published (In progress)" workflow

Patrick L_
Kilo Contributor

I'm trying to create a report of all the KB articles that are currently waiting for Publishing Approval.  I have tried using the approval table, but that does not contain the actual KB Workflow, but when using the kb_knowledge table, I am able to see the Workflow, but cannot specifically report on those KB articles with either  "Published (Pending - has not started)" or "Published (In progress)".

Essentially, I would like to find a way to report on each of these workflow statuses as shown:
find_real_file.png 
find_real_file.png

find_real_file.png

7 REPLIES 7

Patrick L_
Kilo Contributor

Thank you, everyone, for the inputs and suggestion.  I will try to use the report to filter out the workflow based on: Draft, Review, Scheduled for Publish and see.  Basically, I want to make sure that there is a place where I can tell if some KB is stuck and waiting on someone to approve before it can be published.  Knowledge is important and I do not want a miss in the process to deter users from not being able to self-help via KBs.

I monitor articles in 'Review' for this reason and we have an email notification that goes out every Monday morning reminding people of anything pending their approval.

Val Aur
Tera Contributor

Apologies for picking up on this subject/thread but just wanted to ask a question related to reporting. Management would like to create a report on KBAs waiting for approval. We have implemented a 3-layer approval workflow (1st-support, 2nd-owner, 3rd-SMEs). The report they would like to have is a list of all Knowledge Articles pending approval and to whom it is waiting approval from. I tried using the 'sysapproval_approver' table but its not something that I would like to share directly to the management. Is there an alternative way to accomplish this? Thanks!