How do you make a report that shows any knowledge base articles that haven't been modified in the last 6 months?
05/15/2018 460 views
I'd like to get a report that shows our knowledge base articles that have not been modified in the previous 6 months. This way we can review the KB's to see if they are still relevant and up to date. After reviewing previous posts I can get a list of KB names using SELECT ADVISORY.TITLE but I'm not sure how to incorporate the last modified date.
Answer Chosen by the Author
Please log in to answer
SELECT id,title, category, modified
WHERE modified <= DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
Answered 05/16/2018 by: Druis