Knowledge Article Report Showing Update Counts

[nastreutker]

Greetings! I am looking to find a way to pull the number of updates made in a particular month to our knowledge articles. Our Knowledge administrator found us a table where we can get this information for usage. However, any report or information that I have been able to pull only shows the current number of updates to any given article. Would anyone happen to know if this is possible, other than running a report at the midnight hour of the last day of the month?

Thank you very much for your input.

Nichole S.

[Sarup Paul]

Hi Nichole

Trying to clarify before we provide you the right advise- by "update" you mean both create and modifications to all articles within a particular KB (if you are post Fuji)?

Thanks

[nastreutker]

Hi Sarup -

Yes. That is correct. When we pull a normal report against the

kb_knowledge table, there is a field for "updates". An example of the

report I run is below.

My question is can we get historical information for this field? For

example, can we find out how many times articles were updated in February

2016? This would be similar to using the Knowledge Use table see

when articles were opened.

Thank you!

Nichole A. Streutker | Technology Specialist - Senior

"Life begins at the end of your comfort zone." - Neale Donald Walsch

"Between stimulus and response there is a space. In that space is our

power to choose our response. In our response lies our growth and our

freedom." - Viktor E. Frankl

PNC Bank | Service Operations Technology - Operational Support Services

| (o) 513-977-2511 | B2-YB62-01-2 (Cincinnati, OH)

[Sarup Paul]

Hi Nichole

After I little more research, I see that we don't have a direct way of getting you this report.

However, you can try by merging data from two separate tables. The data that we need are in two tables

• sys_audit: This table records changes for configured objects. It includes sys_id of the record, table among other values. We will need to look for the kb_knowledge table. If you want update count across all Knowledge bases, than this should be sufficient.
• kb_knowledge: Assuming that you have more than one KB (Knowledge v3), and would like to get a report per KB- you would need to map the sys_id from sys_audit to kb_knowledge to cross reference the KB (and other fields as required).

Once you have the data collated in a custom table, you would be able to generate the required report.

Hope this helps

Cheers