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

ramak
Giga Expert

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 !

1 ACCEPTED SOLUTION

Alex Mittell
ServiceNow Employee
ServiceNow Employee

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



Screenshot 2016-06-20 19.55.03.png


Screenshot 2016-06-20 20.00.42.png


View solution in original post

21 REPLIES 21

Sure, what I meant was that the DB view which I created has the list of all the attachments. I am looking for the exact attachments that could be downloaded. Like in my screenshot above, the report has the info about the jpeg file, I would be needing the exact file of the incidents...



Hope this helps.



Thanks.


Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Suhas,



You can filter it via filter condition. No?


find_real_file.png


This is what the report looks like...I am actually looking for downloading the attachments. Is it possible ? (If not, I could tell that this is the max that ServiceNow could extract for attachments...)


Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Suhas,



Thanks for the update. Can you check if there is a hyperlink on filename.


Nah mate, no hyperlinks in both pdf or excel.