Report for "new" knowledge articles per month and "updated" articles per month.

Chuck_P
Tera Contributor

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.

 

ServiceNow Article data.png

2 REPLIES 2

Raj_Nishant92
Tera Contributor

Hi @Chuck_P

 

Please use below - 

 

1. Understand the Data Model

  • In ServiceNow, the kb_knowledge table holds the knowledge articles.
  • Key fields to use:
    • sys_created_on: The date the article record was initially created.
    • version: The version of the article.
    • workflow_state: The state of the article (e.g., "Published").
    • published: The date when the article was published.

2. Create a Report

A. Filter Articles by Version and Workflow State
  1. Navigate to Reports > Create New Report.
  2. Choose Table as the source type.
  3. Select the kb_knowledge table.
  4. Apply the following conditions in the filter:
    • version: 1.0
    • workflow_state: Published
  5. Add the published field to ensure you’re capturing the first publish date.
B. Group Articles by Month
  1. In the report configuration:
    • Add published as the X-axis.
    • Use the "Monthly" grouping option.
  2. Use a count aggregation for the Y-axis to total the articles per month.

extmarinabe
Tera Contributor

Did you get any help with this? I'm facing the same issue, but I can't seem to filter on the version.