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

[Patrick L_]

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:
 

[harun_isakovic]

You were in the right direction, report on the kb_knowledge table and just use this condition in the condition builder. (screen attached)

Workflow = Published

Would appreciate a helpful/resolved if it indeed resolved your issue.

[harun_isakovic]

This is just a stage renderer and shows which stage the KBA is in, and which stage was completed/in progress/skipped/not started.

You cannot report on them in the sense you are thinking of.

[Taranjeet Singh]

Hi @Patrick L. ,

On the kb_knowledge table only,

Any stage before Published --> Published(has not started) 

Workflow is Published --> Published(In Progress)

Any stage after Published --> Published(Complete)

So, filter 'Workflow is Draft or Review or Scheduled for Publish' will give 'Published(has not started)' data

and so on..

Please mark reply as Helpful/Correct, if applicable. Thanks!

Taranjeet

[Lesley W]

Hi Patrick,

Here is an explanation of the Knowledge Worklfows: https://docs.servicenow.com/bundle/sandiego-servicenow-platform/page/product/knowledge-management/re...

If you have it on Approval Publish/Retire it requests approval from a manager (or ownership group if you have that enabled).

Approvals: Articles in approval are In Review state before moving to Published state once approved or to Scheduled for publish if set to publish later. If the manager rejects the request, the workflow is canceled and the article remains in Draft state.

Retirement: Articles in approval for retirement are Pending Retirement state before moving to Retired state once approved. If the manager rejects the request, the workflow is canceled and the article remains in Published state.

Therefore, I believe the states you'd want to report on are Draft, Review, Scheduled for Publish, Pending Retirement and Published or Retired. This is what we report on, hope it helps.