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.