Is there a quick way to see which of my KB articles have an attachment without having to go into each article? 

0 Comments   [ + ] Show Comments


Please log in to comment



Honest...I don't believe there is a way unless you attach a label that indicates it has an attachment. That might be a feature request you can submit. You can see what a software title has an attachment, maybe KACE can do the same for KB articles. 

Answered 01/23/2013 by: nshah
Red Belt

  • If you check the ADVISORY table in your database it shows all fields (TITLE, NOTE, CATEGORY) except attachment. I would think it would be in there somewhere. If you took nshah's suggestion about adding labels that say it has an attachment you could JOIN the ADVISORY and ADVISORY_LABEL_JT tables. Then create a query with something like WHERE LABEL.NAME = '<LABEL_NAME>'.
Please log in to comment
Answer this question or Comment on this question for clarity