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.

[Anurag Tripathi]

Hi,

Will a filter like this not help?

This is on attachment table. 

-Anurag

[John Noonan]

That gives me the table but not the articles. And there is a field called Table Sys ID, but when I search for those sys_IDs in KB_Knowledge they are evidently not the sys_IDs for the articles. I can see who uploaded an attachment, but not the record that it is for.

[Allen Andreas · Accepted solution]

Hi,

On the sys_attachment table if you conduct a filter search for "File name" contains and then the extension type, you'll get a list of those records. The "Table sys ID" column contains the sys_id of the record the attachment is associated with and the "Table name" gives you the table.

You haven't provided what you're actually going to do, but as far as how it all relates, I've mentioned that above.

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

[John Noonan]

I have had no luck searching KB_Knowledge for sys_ids in the Table Sys ID field. If that actually is the sys ID for the record then I must be searching KB Knowledge incorrectly.

Should I not be able to just copy one of those Sys_Id records from the Table Sys ID field and then go search for it by Sys_ID in KB Knowledge?

I appreciate any pointer you may be able to give me. @Allen Andreas