How do I extract a report of all the attachments of active Incidents from the past 6 months ?

[ramak]

Hi All,

I have got a requirement to run a report on all the attachments from the list of active Incidents. Can any one of you point me in the right direction of what needs to be done in order to accomplish this task.

Thanks in advance...

Cheers !

[Alex Mittell]

Add the sys_id for the sys_attachment table to the report, then use a macro in excel to generate the URLs to download the attachments in the format:

https://YOURINSTANCE.service-now.com/nav_to.do?uri=sys_attachment.do?sys_id=ATTACHMENT_SYS_ID

[ramak]

Thanks a lot everyone. This solution would do the job!!