Database View Help!

[Snow Angel]

Hello,

I need RITMS for a particular period and find out if they have attachments or not. Since "sys_attachment" table is not reportable. I'm creating a database view but not sure how to proceed. Below is so far I've reached. Please help. TIA

[Harsh Vardhan]

@Snow Angel  Please have a look on below article. just change the table which you want to use. 

https://www.servicenowelite.com/blog/2019/9/5/tasks-with-attachments-report 

Let me know if you have any further questions for me.

Thanks,

Harsh

[Harsh Vardhan]

@Snow Angel 

Sample example. 

Hope it will help you.

Thanks,

Harsh

[Harsh Vardhan]

@Snow Angel  Did you get a chance to validate my response ? 

Let me know if you have any further questions for me .