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

Chuck Tomasi · ‎06-20-2016

Hi Suhas,

This is a bit of an unusual request. Can I ask what the business requirement is behind this report?

Pradeep Sharma · ‎06-20-2016

HI Suhas,

Please refer.

Re: I need to get all attachments for specific table. How do i get it?

Chuck Tomasi · ‎06-20-2016

Wow, Pradeep! Where do you come up with these old discussion topics?!

Suhas,

If you follow the instructions in the link Pradeep sent you to create a database view, you can then use that database view as the table name in your report. That will give you the solution you need.

Reporting - ServiceNow Wiki

ramak · ‎06-20-2016

You know I was about to say the same to Pradeep.

Sure, will check the discussion link & update on how I go...the requirement is for all incidents assigned to a particular group that the group manager needs to look at. (Don't know for what joy though )