Extract a report of all the attachments or the attachment count related to change request ?

[Shristy Agrawal]

Extract a report of all the attachments or the attachment count related to change request ?

from report- as a column of attachment with change request number

[VigneshMC]

If you want list of attachments from change_request table, below link will give you that, but if you want with change number, then you need to create a database view relating sys_id of change request and table sys_id of attachment table

https://instance_name.service-now.com/sys_attachment_list.do?sysparm_query=table_name%3Dchange_request

[Shristy Agrawal]

I want with change number.

Please help me with screen shots

[VigneshMC]

create an database view , like below

and then you will be able to see data as you expect

Update list view to see required fields

[Shristy Agrawal]

Please see and help