Where are attachments saved for 'File Attachment' field type values?

Pranshu3 · ‎10-14-2019

When we have a 'File Attachment' type field in a table, and we attach a file in that table's form for that field; where are the attachments saved?

As in, in which table are the field's attachment records saved?

Ankur Bawiskar · ‎10-14-2019

Hi Pranshu,

all attachments are stored in sys_attachment table and metadata for that attachment is stored in sys_attachment_doc

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Pranshu3 · ‎10-14-2019

Thanks for the replies, but

My record was related to Demand (dmn_demand) table, but the attachment came in as 'ZZ_YYdmn_demand' as the file attachment is related to a field of the table.

Could you please help me with more details?

Ankur Bawiskar · ‎10-14-2019

Hi Pranshu,

When you have a File attachment type of field the data gets stored in sys_attachment table with the table name as starting with ZZ

Are you adding the txt file to that file type of field on form?

Regards

Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader

ah16 · ‎05-05-2020

Hi Ankur,

Can you please look at my similar question?

https://community.servicenow.com/community?id=community_question&sys_id=fbb9fa9e1bec9010d01143f6fe4b...

Thanks,

Ashraf