Include Attachments in Report

[gnunez]

Hello all,

We have a catalog item that requires fulfillers to include an attachment before closing out the task. Once all work is completed that attachment is included in the email notification and is sent to the requester.

My requirement is to create a report on how many of these items are submitted and if possible include the attachments. I have already scheduled the report, but have had no luck on including the attachments. Is this is even possible?

Thanks,

Grace

[SanjivMeher]

It could be difficult using reports.

You may have to create a script and provide link to the Servicenow attachments in the email body

[Michael Ritchie]

I don't believe its possible.

A work around would be to create a URL field on the task that gets populated with the attachment URL when its attached and closed.  Then include that URL in your report where users can click the URL to download the attachment for each task.

[Goran WitchDoc]

I would say not impossible, but it require some coding in the backend to make it work and not sure what the reason is for. Since I doubt that they go through all the attachments. And if they instead looked at the report instead ServiceNow, they could drilldown to the specific record and also then get the attachment.

In this case to make it work, I guess you would need a BR on the email table to trigger when the email for this report is being created and the go to the attachment table and copy all those attachments over to the email.

//Göran