How do you make a report that shows any knowledge base articles that haven't been modified in the last 6 months?
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.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
Druis
6 years ago
Top Answer
Try this:
SELECT id,title, category, modified
FROM ADVISORY
WHERE modified <= DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
Comments:
-
Thank you so much Druis, that worked! - Adam Armstrong 6 years ago
