How can you report on Net-New KB articles created within a certain time frame?

Ryan Dong1
Giga Contributor

‎01-14-2021 09:44 AM

Hello,

I'm trying to figure out how to create a report on Net-New KB's created within a specific time frame. I am running the Paris version of ServiceNow with Version Control enabled for Knowledge.  I've been struggling a while with this, since I want to report on net-new knowledge created (say within 1 year, or 1 month).  This knowledge could have several revisions before I even report on it.  Is this type of report possible?  Even if it's just for a 12 month time span.

So for example:  KB00001 is created.  It is modified several times and it's sitting at version 5.0.  I just want to report on the creation of the base version, not all of the modifications.

Thanks!

0 Helpfuls
  • 1,835 Views
6 REPLIES 6

sachin_namjoshi
Kilo Patron
Kilo Patron

‎01-14-2021 09:54 AM

KB versions are maintained in kb_version table.

This table maintains all versions of KB article.

You can report on kb_version table to find out base version of KB articles.

 

Regards,

Sachin

Ryan Dong1
Giga Contributor
In response to sachin_namjoshi

‎01-14-2021 10:01 AM

How can I manipulate this to show net-new knowledge though?  I want to report on version 1.0, meaning this is the net-new base version, but it could be version 5 within a few weeks.  I would like this result to come back as "1 new KB" and not report on the version updates.  Any suggestions?

0 Helpfuls

sachin_namjoshi
Kilo Patron
Kilo Patron
In response to Ryan Dong1

‎01-14-2021 10:10 AM

In that case, you can directly report on kb_knowledge table and make use of latest flag on kb_knowledge table which reports latest KB article with latest published version.

 

find_real_file.png

 

Regards,

Sachin

Preview file
185 KB

Ryan Dong1
Giga Contributor
In response to sachin_namjoshi

‎01-14-2021 10:17 AM

Those filters don't work.  They simply report on articles that are published.  Published articles obviously are the latest version.  I need to report on NET-NEW articles that were published over the last year.  These articles could have been edited and/or retired over that time frame.  So for example: KB01 is created, it's KB01 v1,0.  Over the next few months there have been several edits and revisions.  KB01 is now at v6.0.  The report I would like, should only report back 1 net-new article.