How to find attachment attached to which incident

[shaik_irfan]

Hello,

I have an attachment which was attached to an incident but i didnt the number can anyone help me out how to find the attachment ?

I have attachement name i:e: Irfan.xls

[khusboo1]

you can go to sys_attachment table.All the attachments received by service-now are present in that table,you can search your attachment there by the name.Table sys_id field present in attachment table will contain sys_id of the incident record.

[shaik_irfan]

I can find only table sys_id but not corresponding sys_id

[Ashutosh Munot1]

HI IRfan,

Go to sys_attachment table as well as sys_attachment_doc table and check you file name.

Thank you,

Ashutosh Munot

[Jaspal Singh]

Hi Irfan,

You can look for sys_attachment table & then search for table that has table name & table sys_id corresponding to sys_id for record.