Where are user photos saved?

[kungfuu72]

Does anyone know where and/or how user images are saved in ServiceNow?

This is the field photo on the sys_user table. This dictionary type extends the String type of field.

It may be my assumption that this field (as a string) is just translated binary and that the images aren't saved like that are saved in the db_image table.

I'd like to know if I'm on the right track or if this is totally off.

[Michael Ritchie · Accepted solution]

They are stored in the sys_attachment table like all other attachments.   Here is an example:

[kungfuu72]

Got it.

[xiaix]

Since this is the case, then why is there a "photo" field on the sys_user table if nothing is stored there?

[Michael Ritchie]

Photo is an "image" type field.  Images behave differently than other attachments in that the actual picture is displayed on the form or in a list unlike other attachments where you need to click on them to open them in the respective application.  So think of the photo/image type field as a "bridge" or API to show the image visually.  I hope this helps.