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 !

[Pradeep Sharma]

@Chuck, I remember all the questions on community 🙂

@Suhas, would appreciate if you can close this thread if this answers your question.

Database Views - ServiceNow Wiki

Reporting - ServiceNow Wiki

[Alex Mittell]

Wow you guys are fast, in the time it took me to take a couple of screenshots in my instance you already answered the question.

[Alex Mittell · Accepted solution]

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

[ramak]

Thanks Alex, can I also download the reports from these incidents once after the creation of DB view ?

[Chuck Tomasi]

Yes you can. You can schedule delivery, you can create an XLS, same as any other standard report.