Report for "new" articles published per month and "updated" articles per month

[Chuck_P]

Hi,

Help needed! We want to know how many new knowledge base (KB) articles are published per month. By "new" we mean v. 1.0 articles that have never existed in the KB.  I thought the "created" date would indicate when an article was first published, but it seems the "created" date is updated with each update and/or republish date. I was thinking I'd report the number of v 1.0 articles per month. How can I find the date v. 1.0 was published for the article and report the total out? Or is there a different a better way of getting the report I seek: New published articles per month.  

 

[Dave Littlejohn]

You would need to create a trend report with a filter for display number contains " 1.0" (note the space before 1.0 as I didn't want to include v11.0, 21.0, etc.) and the trend by set to created and monthly:

[qprinsloo]

Maybe I'm misunderstanding the question but your screenshot is showing version 6.0 with that created date. You'd need to view the version 1.0 of the same article to get the original created date. Version 1.0 should have a different created date than the latest. The only thing tying the articles and versions together is the "summary" which should be the same article number. If you just want to report on articles created this month then filter by version contains  1.0 as well as including created=this month and latest=true in your conditions. That should get you the articles created this month. If you need to trend that, then you'd need to trend by created instead but still include the condition to only look at 1.0 as well as whatever timeframe you want to account for.

[Eoghan Sinnott]

Hi Chuck, 

To get New articles only (versions 1.0) you need to run a report on the kb_knowledge table and add in the condition Version -> Version is 1.0.

Then once you add in your date conditions (Created on) it will only show you new articles that were created within this time frame. The Created field is unique to that Version of the knowledge article, so when you create a new version of an article, that's why it is showing up in your report, even though the base version may have been initially published years ago.

Regards, 

Eoghan

Please consider marking my reply as Helpful and/or Accept Solution, where applicable. Thanks!

[Leri Andrews]

I found the version table to be more useful for this than the knowledge table. If you are trying to find out 'new articles this month' then using the knowledge table is fraught with sneaky little traps - you'll have to exclude those where v1.0 is 'outdated' because that's not new. You might use 'latest=true' as well.