It is possible to run a report that shows new vs. updated articles?

[Aerin]

I'd like to run a monthly report that would show the number of newly created articles and one that would show the number of articles updated that month, e.g., the version 1.0 existed on August 1 and on August 18 version 2.0 was published. I'm not too fussy about whether this is one comparative report or two separate ones, as long as I get the two totals.

I'm just not sure if there is an OOB condition that I can use to accomplish this. I've tried playing around with the Version condition, but can only get it to show me *every* version (0.1, 0.2, 0.3, 1.0, 1.1, etc.) which is too much detail.

Any insight would be appreciated!

[Lauren Methena]

Good question - and it will be a tough one. Because even if you can run a report for it, you may still run into two behavioral issues from your authors that can muck up the accuracy: 

1. Articles that are started but not published. (I often get requests for an article, I set up the article, but final approval doesn't come in for a few more months.)

2. Articles that get edited right away because the person entering them published, made a mistake, edited the article, and then republished, creating version 2.0 right away. In which case it's likely you could have the article show up both in the "published" report and the "updated" report in the same month.

This is tricky. I've not had much luck yet. 

Concerning your version numbers, I'm assuming you've tried version > is equal to > 1.0 (etc.) in your reporting configuration? Or, version > does not end in > .01 or .02?

You'll need to set workflow > is > published - or - not draft, review, pending retirement - something like that. The other issue I've run into with reports (mostly filters applied in list view) is that ServiceNow wants to show you all the articles with a version 1.0 - including outdated 1.0 versions. (Sharing in case someone has a solution to this specific problem.)

You could possibly run a daily report to find all the 1.0 version articles that are published vs. outdated and then compile at the end, but that seems really manual and labor intensive.

I hope this is helpful in getting you or someone closer to a better solution. I'll be following.

[Leri Andrews]

I've had some success reporting off the kb_version table