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

ramak · ‎06-20-2016

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 · ‎06-20-2016

I would use a database view, then use the filter tool to create a report against that view. Like this:

View solution in original post

Pradeep Sharma · ‎06-20-2016

Hi Suhas,

This will behave as any other report.

Alex Mittell · ‎06-20-2016

Yeah after you run the report you can just add ?CSV to the end of the URL to export as CSV, you can also do the following formats too.

Excel	?EXCEL	10,000 rows	Exports table records as a Microsoft Excel spreadsheet.
XML	?XML	10,000 rows	Exports table records as an XML document.
PDF	?PDF	5,000 rows	Exports table records as a Portable Document Format file

Pradeep Sharma · ‎06-20-2016

On that lines the below link will be helpful.

Exporting Data - ServiceNow Wiki

ramak · ‎06-20-2016

Yeah, was able to create the DB view & it looks like this :

Is there any table which would also download all the attachments as this provides the list of all the attachments ?

Pradeep Sharma · ‎06-20-2016

Hi Suhas,

Sorry, I didn't get you. Can you please elaborate further.