Where do embedded images within KB articles get stored?

[Jay Gamblin]

In the Test markup I see the tags are like this: src="/groupadd2.jpgx"

But in this case I've searched for that file name in db_image and sys_attachment tables and cannot find it.

[adamjgreenberg]

Jay,

I see the filename in the text of KB0012027, and like you I cannot find this in the db_image.

I'm thinking this may be cached information but my concern is if we have support invalidate the table cache for kb_knowledge, this attachment will end up missing.

These are the actual attachments on db_image and sys_attachment that start with SH_Jabber and end with .png

I'm going to do some testing in my own demo and see if I can replicate the same results you are observing.

[Jay Gamblin]

Thanks.   Yes I see this happening in other instances including Production.  

We are attempting to find orphaned image so we can clean them out but was puzzled over where these are stored since I could not find many of them.

[adamjgreenberg]

Jay,

Is the intention to remove the attachment? Or do you need this attachment to be present?

[adamjgreenberg]

Jay,

I've been testing and it would seem that if you embed an image and then delete the file from db_image, the image remains.

I've even go so far as to invalidate the table cache for db_image, kb_view and kb_knowledge to no avail.

I'll speak with a few other colleagues of mine and see if anyone has other ideas or more information.

[adamjgreenberg · Accepted solution]

Jay,

The images are stored in the browser cache. If you are able to clear this from each user, the images that are deleted will no longer appear.