How to fetch the attachment data in incident table

[Nagesh5]

Hello Experts,

We have around 10Lakhs incidents in the system and we are looking for way to filter the incident which are having attachments and we are ware we can achieve through database view by combining the attachment and incident. Looking for the suggestions is it best practice to create database view or any performance impact on this or any alternative solution available in system for reporting purpose?

Thanks,

Nagesh Kalava

[Gangadhar Ravi]

Hi @Nagesh5 ,

yes, you can build database view. Please refer this post if need help.

https://www.servicenow.com/community/developer-forum/how-do-i-extract-a-report-of-all-the-attachment...

Please mark my answer correct and helpful if this works for you.

[Nagesh5]

is this good practice to build database view?

Thanks,

Nagesh Kalava