How to create a report on Published and Republished Knowledge articles

[Sriram28]

Hello,

How we create a report on Published and Republished Knowledge articles

Or

How we can differentiate published and republished articles.

Thanks in advance

[Abinaya Sekar]

You can differentiate published and republished Knowledge Articles by checking the version field on the kb_knowledge_version table.
Articles with Version = 1 are first-time published, while Version > 1 means they were republished.
Create your report on the kb_knowledge_version table, not kb_knowledge.
Filter Version = 1 for published and Version > 1 for republished.
You can also group by “Version” to show both in a single report.

[Sriram28]

Hello @Abinaya Sekar 

Thanks for your time and response.

I have a query here, how we can say "Version > 1 for republished", because it can be (checkout and published mutiple times).

Only when retired and repblished, is something we can considered it as Republihed.

Please suggest how we can differentiate them.

[Sarthak Kashyap]

Hi @Sriram28 ,

Please check the report for Published KB artciles

If you want to differentiate articles navigate to kb_knowledge table and check for workflow and versions.

Please mark my answer correct and helpful if this works for you

Thanks and Regards,
Sarthak