FInd Knowledge articles with particular related attachments.

[John Noonan]

How can I get a list of Knowledge Articles with particular types of attachments? My problem is that my organization is no longer allowing the download of legacy Microsoft Office formatted files (xls, doc, and ppt) and I need to find the articles that have those attachments. I have looked at the sys_attachment table and I have found the attachments that are applicable, however I have not found a way to tie that back to the article.

[Allen Andreas]

Hi,

Yes, you should be able to. I did, for example:

I'll expand the filter down too so you can see:

Please mark reply as Helpful/Correct, if applicable. Thanks!

[John Noonan]

Really odd for me here on my instance. I am doing exactly what you did there and finding none of these sys_ids in my kb_knowledge table. I am trying to figure out what I am doing wrong and will likely say something here when I figure it out. I am even pasting the things into notepad before pasting them into the my search to ensure that there are no odd characters. I have exported them as a csv file and have even tried doing an "Is One Of" filter based on what was in that.

[John Noonan]

Okay I got it. Thanks for your help. I really appreciate the people like you who help here in the community.

[Allen Andreas]

Hi,

Glad you got it!

I was prepared to analyze some screenshots of your effort if you were still having issues, haha.

Feel free to mention me @Allen Andreas in any future questions/posts you have and I'll be glad to assist.

Take care! 🙂