/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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 Summary:
0 Comments   [ + ] Show comments

Comments

  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.

Answer Chosen by the Author


Answers

0
Try this:

SELECT id,title, category, modified 
FROM ADVISORY
WHERE modified <= DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
Answered 05/16/2018 by: Druis
Second Degree Green Belt


Answers