Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report of incidents with attachments

Joe78man
Mega Contributor

‎03-19-2019 01:19 PM

Hello guys, 

I'm running a report of the incidents and would like to be able to pull whether the incidents have an attachment or not. A count of attachments would suffice. Is there any field that pulls this from the table 'Incidents'?

Thanks,

Labels:
0 Helpfuls
  • 5,863 Views
2 REPLIES 2

sachin_namjoshi
Kilo Patron
Kilo Patron

‎03-19-2019 01:21 PM

You will have to create 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

 

Regards,

Sachin

Joe78man
Mega Contributor

‎08-23-2019 01:12 PM

So much trouble and permissions (I'm not allowed to pull from sys_whatever tables) for something so simple.

It'd be useful to have a field that simply counts the attachments as there is for priority change, reassignment, reopen, pending.