How to create report on published knowledge articles without older versions

[SNhydrone]

Hi! Any insights on how to create a report on published knowledge articles without the older versions? When we do knowledge article reporting, there are duplicate records and it's probably versioning. But open to how others are doing this as I expect this to be a common report.

Thanks in advance!

[AndersBGS · Accepted solution]

Hi @SNhydrone ,

If you create a report based on kb_knowledge table with the conditions:

"latest is true" and "workflow is published", then you will get only the latest articles which are published.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders