How do I create a report on KB articles using original version creation date?

Cameron17
Tera Contributor

How do you create a report that shows published knowledge base articles where the original article version was created on a certain date or within a certain set of dates? 

 

I have been trying to do this using the kn_knowledge table but the system will only look at the currently published article version or the previous article version but not the original article version.

2 REPLIES 2

Community Alums
Not applicable

Ravi Chandra_K
Kilo Patron
Kilo Patron

Hello @Cameron17 

You can identify the original article with Version associated with it.

(The later versions will have same KB number but version number will be different)

 

You can create a report on kb_knowledge along with original version and you can report on it

 

 

Please mark the answer as helpful and correct if helped. 

Kind Regards,

Ravi Chandra